Please, I need help carrying out Excel reconciliation.
I want to locate each unique ID and its corresponding Amount on the Settlement report, match it off, and remove them using the same unique ID and Amount on the statement report. After all the reconciliations, I want to be left with only unmatched transactions on both reports.
Easier way would be to use join activity …please follow below steps
Read first report into dt1 and second into dt2
Now use join datatable activity with join type as outer and columns as ID and amount from both tables
Now use a filter datatable on the joineddt and filter on empty id and empty amount for the dt1 related columns and keep those rows which are the non matched rows for dt2
Repeat same filter but now for dt2 related columns from joineddt and keep those rows which are the non matched rows in dt1
Can you please be a bit more elaborate? Can’t find outer join in UiPath join activity. Is it possible for you to please send a screenshot of the whole process so I can understand better, please?