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
in the blog, i think from field of filter array should have mapped to select action's output from first excel data. Then things would have work
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.