Reconciliation of tables

Hi there,
i am comparing two columns from different table using nested for loops.
what i want to achieve is that to perform an action when the loop has checked all the rows of a column and not find a match.

You could use a Join Datatable activity to achieve this. Do an Inner join on tables you’re comparing where the column value of the first table is equal to the second. Then perform actions on all rows of the resulting table from the activity.

This approach would only work if you are sure both tables has the same number of rows and you only need to compare rows at the same index, please try the Join Data Table activity using the Inner type and let us know if need more help.

1 Like

Please refer Comparing one column contents of two excel file

1 Like