Regarding matching two different excel files

Question

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 Answer

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

grossal · Accepted Answer

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 Answer

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