Comparison of fields in same sheet

[rachana19]

Hi All,

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

Main	Source 1	Source 2	Source 3
Name	City	Country	Name	City	Country	Name	City	Country	Name	City	Country
Jon	Hamburg	Germany	Jon	Hamburg	Germany	Jon	Hamburg	Germany	Jon	Hamburg	Germany
Evan	Mumbai	India	Riya	Bangalore	India	Evan	Mumbai	India	Evan	Mumbai	India
Lily	Sydney	Australia	Lily	Sydney	Australia	Thomas	Milan	Italy	Gary	Sydney	Australia

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 

[rachana19]

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

[rachana19]

Hi All,

Could anyone please help in this regard?

[atcodedog05 · Accepted solution]

Hi @rachana19 ,

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 🙂

[deepaksadija85]

Could you share the sample data source in excel.

[rachana19]

Thanks for the solution. I could use this to compare the fields from the same source.