Comparison of fields in same sheet

Hi All,

I am working on a use case where I have below sample data -

Here I need to compare the main section with all sources - source 1, source 2 and source 3.

For e.g., Compare Name in Main with Name in Source 1, Source 2 and Source 3. If matches write Source 1 Name value in output in green color

For e.g., Compare City in Main with City in Source 1, Source 2 and Source 3. If does not match write Source 1 City value in output in red color

There are more scenarios. But to start with, could you please help me to understand what would be the best approach?

Shall I first split input file to 4 different inputs then compare? Or can I do it keeping them in same input.

Thanks a lot,

Rachana

Workflow

Accepted answers

Quick fix.

Change the "start data import on line" in the input tool configuration to 2. Like below.

The data will be transformed to like below which will be easy for manipulation and applying condition.

Hope this helps

Cheers and Happy Analyzing 🙂

Putting sample data again in image format as earlier format is not correct

Hi All,

Could anyone please help in this regard?

Could you share the sample data source in excel.