How write row data

Help Studio
, , ,
1

hi
i’ve my data like this

1111
1111458×580 5.5 KB

now i need the data in the second column like

  1. i need read the two columns and in the the if condition row1 names to be found and if the match is found i need to write the data for that row in a different column
    e.g., if row contains “policy_annual_premium:” then i need the data opposite to it which is “1328.26” be wrote in the different excel.

can anyone help me how can this be done

2

Hi @lakshmi3

I am getting your process well , could u explain it little better?

3

i’m scraping data from pdf and saving it to the excel like this

1111
1111458×580 5.5 KB

now we have 1 column wiith the header names and the another column with the data for that particular column
now i need to write the data in to the another excel if it matches the name i searched for suppose
image
image1920×1080 265 KB

this is the flow i’m trying

  1. if the row has the name i’m searching for then i want the data in the next column to be wrote in a different excel
    image
    image1920×1080 275 KB
4

It seems like u are updating the same excel but writing to different excel right?

5

1111
11111920×1080 138 KB

this is my first excel wwhere i’ve save the data from the pdf and need to compare the names and if the name matches then i need only the data to be moved and paste in the another excel which alreay has the headers as same
2222
22221862×532 10.7 KB

6

Hi @lakshmi3
So this means u had to do for all rows in first excel?

7

yes every need to read and verify wheathr it is matching or not

8

Hi @lakshmi3
Just thought of this logic as well
Main.xaml (14.9 KB)
Excel1.xlsx (8.9 KB)

This is the sample excel file added and main file.xaml.

This is based on ur concept

Let me know if it works

Regards,
Nived N

9

HI
CAN U SHARE THE XAML ONCE AGAIN IT’S NOT OPENING

10

this is the error i’m getting
image

11

Can u show the value of index ?

12

can u share the xaml once

13

@lakshmi3
I had shared the same file earlier right?

14

its not opening actually
this is the index i’m getting

image
image1920×1080 241 KB

15

hi
i’ve tried the same code with the multiple pdfs but i’m getting the index error can u tell me why

image
image1920×1080 255 KB

16

Can u just print what is index ?

17

can u tell me clearly what should be done