Read data in excel and write it in another file?

[fairymemay (noona)]

If I have 2 file excel.
I want to read column C in file 2 , If found in file 1 write “Y” in rows follow data P… in column A as below.

Please guide me about it.

[songoel (Sonal)]

You can use a simple method to do this:

Read File 2 using Read Column & save it in a variable.

Now in File 1, using a For Each Row, look if row.Item(0).ToString is contained by the data structure from File 2, just mark row.Item(1) as “Y”.

[manjula_rajendran]

@fairymemay ,

Find the attached workflow for you.

Hope it helps.

hover.xaml (12.6 KB)

Thanks,
Manjula

[fairymemay (noona)]

@songoel In file2 some row have 1 data (P13) , 2 data (P1,P2)

Example : rows2 have P1,P2 —> I want write “Y” in file 2 in row P1 and P2.

How to edit it?

[manjula_rajendran]

@fairymemay ,

Run the workflow i’ve given. I’ve taken the example as same as yours.

In If condition we are checking for “contains” it will check for both values.

Thanks,
Manjula

[manjula_rajendran]

@fairymemay , see the files i’ve taken for your workflow

file1

No	Get File Status
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10

file2
No
P1,P2
P3
P4,P5
P8,P10