Comparison of two data files

[Polite123]

Hi Team,

I have a file which has around 120000 rows and 70 columns.

So need some help for quick comparison using Alteryx.

I have two files- User generated output file and Alteryx generated output file.

Need comparison between two.

For eg

User file:

Code	Col_1	Col_2	Col_3
A	1	5	Train
B	2	6	bus
C	3	7	tram
D	4	8	cycle

-Ateryx file:

Code	Col_1	Col_2	Col_3
A	1	5	Train
B	2	2	bus
C	4	7	bike
D	4	8	cycle

Comparison:

Code	Col_1	Col_1	Remark	Col_2	Col_2	Remark	Col_3	Col_3	Remark
A	1	1	TRUE	5	5	TRUE	Train	Train	TRUE
B	2	2	TRUE	6	2	FALSE	bus	bus	TRUE
C	3	4	FALSE	7	7	TRUE	tram	bike	FALSE
D	4	4	TRUE	8	8	TRUE	cycle	cycle	TRUE

I need above comparison for 70 columns.Is there any other way to achieve above comparison or please provide solution to achieve above comparison TABLE.

Thanks in advance.

[Qiu]

@Polite123 
Not so pretty, but hope get what you need.

[Polite123]

Hi @Qiu ,

Thanks for the solution but this is not workfng as expected.

Any other solution if possible?

[Qiu]

@Polite123 
Can you explain what part went wrong? so I can fix.

[Polite123]

Hi @Qiu,

It is not working for 70 columns and large number of duplicates are getting generated after join tool.

It would be great if column comparison is done vertically as shown above in first thread(third table).

Thanks