Hi, I am new with PA and trying different solutions.
I would like to compare the contents of two excel files and as a result get only the data that is in file-2 and not in file-1
Unfortunately there is an error that I can't deal with. It concerns the part of comparing two arrays. Filter array doesn't filter the elements of the array correctly. items('Apply_to_each')?['Row'] shows the elements of the array from file #2 but doesn't compare with item()?['Row'] - the array from the data of file #1. As a result, I have an empty array
How to compare these two tables so that as a result you get only the data that are in file-2 and bypass those that are in file-1