Merge two data tables and delete set of the same items


I want to merge two Data Tables. I have Excel files with the same tamplates (Names of colums are the same in both files). I want to merge this Data Tables to see row by row from input files.
Next step is to delete every set of the same rows. I do not think about duplicates because then I still have one of the row. I want to delete rows if they have the same data.

Please help.

Hello @aleksandra.plichta5

I hope you are having 2 excels with same rows and you want to do a comparison to find the similar and disimilar rows you can do as mentioned in the below video.

you can follow this worflow this workflow.
It will help you
sample.xlsx (10.5 KB)
MergeDataTable.xaml (8.6 KB)

@Rahul_Unnikrishnan thank you so much! That is what I was looking for.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.