Comparing two sheets

[Fayzeh]

How to find the unmatched data when comparing two sheets including same headers?

[stataltgee]

@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.

[Fayzeh]

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 : 

Request number	Record ID	City	Check in date	check out date
1	1	1	1/1/2025	15/1/2025
2	2	2	1/2/2025	1/2/2025
3	3	3	1/3/2025	1/3/2025
4	4	4	1/4/2025	1/4/2025
5	5	5	1/5/2025	1/5/2025

[Fayzeh]

And please note that the data is not in the same order 

[Raj]

@Fayzeh it will be great if you can add both the sample sheets and the output you want to see
will try to help with flow.

[Fayzeh]

Sure, please find below tables, I need to compare both and find the unmatched data for each column :

Request number	Record ID	City	Check in date	check out date	Name
1	1	1	1/1/2025	15/1/2025	Sami
2	2	2	1/2/2025	1/2/2025	farah
3	9	3	1/5/2025	1/22/2025	Lena
4	8	4	1/4/2025	1/4/2025	Hiba
7	N/A	5	1/5/2025	1/8/2025	Aya

Request number	Record ID	City	Check in date	check out date	Name
1	1	1	1/1/2025	15/1/2025	Sami
2	2	2	1/2/2025	1/2/2025	farah
3	3	3	1/3/2025	1/3/2025	LINA
4	4	4	1/4/2025	1/4/2025	Samer
5	5	5	1/5/2025	1/5/2025	Aya

[Raj]

@Fayzeh 
please find attached

Please let me know in case your requirement differs.

[Gaurav_Dhama_]

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.

[Gaurav_Dhama_]

And if you want the output in same column order as the original as well, check the below.

[Fayzeh]

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:

Confirmation Number	Workday ID	Transferee (guest)
345	4543	Aalaa
434	555	Aashirwad
555	7976	Abdallah
666	8888	Abdelrahman
878	4567	Mahmoud
123	2223	Abdelrahman
6665	76666	Abdul Rehman
546	454	Rais

Confirmation Number	Workday ID	Transferee (guest)
232	4543	Aalaa
434	464544	Aashirwad
555	7976	Abdallah
666	4352	Abdelrahman
878	4567	Mahmoud
989	9999	Abdelrahman
6665	76666	Abdul Rehman
45778	5555	Rais