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.

0116-Polite123.yxmd