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.
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”.
@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?
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
@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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.