Hi, I have two separate excel files of 1 column each but might have different number of rows. I need to compare these two files and find the difference between them. For example:
File 1 contains:
File 2 contains:
So I need the result to look like this:
So I have a workflow, but I cannot make it work. My workflow is:
- Read excel 1 and keep it in a datatable, dt1.
- Read excel 2 and keep it in a datatable, dt2.
- For each row1 in dt1
For each row2 in dt2
If row1(0).ToString = row2(0).ToString
Write cell in another excel file, say output.xlsx, value row2(0).ToString
Increase counter by 1
The counter variable has default value of 1 and scope is entire sequence including step 1 and 2. This isn’t working…so really in need of your help!
Thanks in advance!