Regarding matching two different excel files

[tani1989]

Hi, 

Can anyone help me with steps I should take to match two different files(select only the common columns) and the result file should Highlight the results that are not matching.

Thanks

[AMansour · Accepted solution]

Hi @tani1989 

If you want just to compare 2 data set's headers to determine the non-matching fields you need to transpose both data files then use join multiple to output all records (matched or not).

Otherwise, don't hesitate to send un example,

Cheers

[tani1989]

Thanks for your help.

Please find below the example of how i want the output:

Input 1

Name	Value1	Value2
ABC	Yes	No
DEF	No	Yes

Input 2

Name	Value1	Value2
ABC	No	No
DEF	No	Yes

Output

Name	Value1	Value2
ABC	Highlight (mismatch)	No
DEF	No	Yes

[grossal · Accepted solution]

Hi @tani1989,

here is a quick way to do it:

Output:

Workflow attached. Let me know if this is what you want.

Best

Alex

[AMansour · Accepted solution]

Give these a try and let me know if it works 😉

[tani1989]

Thank you all for you help.