How to find the unmatched data when comparing two sheets including same headers?
@Fayzeh Join the 2 data inputs using join tool. You'll have to do this using a common key column between both the data inputs. Then when u run the workflow you will see some records that are not matched in the left and right streams of the join tool.
Hello, thank you for your support.
I have tried this, but I need to compare multiple headers, like below, with another sheet including same Headers, please assist :
And please note that the data is not in the same order
@Fayzeh it will be great if you can add both the sample sheets and the output you want to seewill try to help with flow.
Sure, please find below tables, I need to compare both and find the unmatched data for each column :
@Fayzeh please find attachedPlease let me know in case your requirement differs.
Attached is the workflow that will take care of all the column headers (Existing or new) and give you the difference in the tabular format.
And if you want the output in same column order as the original as well, check the below.
I tried this but the result is not correct.
I need to see the unmatched data for the below in a separate sheet with same headers, please assist:
I just tried it with the new data and seems to be working fine.
If you want to see the complete row even if one single value is different in it then, check out the attached workflow.
I am using record ID that came out of join from pervious flow to get the details back, effectively maintaining the column order.
.
