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:
123
abc
456
File 2 contains:
123
abc
xyz123
456
789
So I need the result to look like this:
xyz123
789
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
Break
Else
Write cell in another excel file, say output.xlsx, value row2(0).ToString
Increase counter by 1
Break
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!
@NIVED_NAMBIAR
lets do one thing: as it is the post of @abdul.aziz1 just keep it clean for his topic. In case of your question just open a new topic. The join operator will still be = and not != (!= has a different meaning, see description above on how to detect the matchers and non matchers)