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
Solved! Go to 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
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 |
Hi @tani1989,
here is a quick way to do it:
Output:
Workflow attached. Let me know if this is what you want.
Best
Alex
Thank you all for you help.