desDear expert, I have 2 data files which I need to compare column by column with reference to a common column. Could you Pl help me to build my workflow with this kind of data. Example sheets are attached. This is the base file that will be used for the comparison, and considering the data is always correct in this file CityCat CountDog CountCow CountIndia50000436433352435USA100023522452Germany43232324242141Pakistan456546234212432China21112132214543SriLanka7656653212543543Bhutan43233212145322Indonesia432512342167566 This is new transformed file which need to be compared with the source file column by column CityCat CountDog CountCow CountIndia50000436433352435USA99923522452Germany43232324242141Pakistan456546432343212432China21112132214543SriLanka7656653212543543Bhutan43233212132423Indonesia432512342143245NewZeeland543252134564456 This is final consolidated data file after comparison. Comparison has been done with reference to city as this is common data in both the files. Count comparison is updated in next column of the consolidated file with match or check result with color CityCat CountComparisonDog CountComparisonCow CountComparisonIndia50000MATCH436433MATCH352435MATCHUSA999CHECK2352MATCH2452MATCHGermany43232MATCH32424MATCH2141MATCHPakistan456546MATCH4323432CHECK12432MATCHChina21112MATCH13221MATCH4543MATCHSriLanka765665MATCH3212MATCH543543MATCHBhutan4323MATCH32121MATCH7686CHECKIndonesia4325MATCH123421MATCH67566MATCHNewZeeland54325CHECK2134CHECK564456CHECK Compare column by column.xlsx

Compare tow sheet column by Column & update Match and mismatch with color in final sheet

desDear expert,

I have 2 data files which I need to compare column by column with reference to a common column. Could you Pl help me to build my workflow with this kind of data.

Example sheets are attached.

This is the base file that will be used for the comparison, and considering the data is always correct in this file

City	Cat Count	Dog Count	Cow Count
India	50000	436433	352435
USA	1000	2352	2452
Germany	43232	32424	2141
Pakistan	456546	2342	12432
China	21112	13221	4543
SriLanka	765665	3212	543543
Bhutan	4323	32121	45322
Indonesia	4325	123421	67566

This is new transformed file which need to be compared with the source file column by column

City	Cat Count	Dog Count	Cow Count
India	50000	436433	352435
USA	999	2352	2452
Germany	43232	32424	2141
Pakistan	456546	4323432	12432
China	21112	13221	4543
SriLanka	765665	3212	543543
Bhutan	4323	32121	32423
Indonesia	4325	123421	43245
NewZeeland	54325	2134	564456

This is final consolidated data file after comparison. Comparison has been done with reference to city as this is common data in both the files. Count comparison is updated in next column of the consolidated file with match or check result with color

City	Cat Count	Comparison	Dog Count	Comparison	Cow Count	Comparison
India	50000	MATCH	436433	MATCH	352435	MATCH
USA	999	CHECK	2352	MATCH	2452	MATCH
Germany	43232	MATCH	32424	MATCH	2141	MATCH
Pakistan	456546	MATCH	4323432	CHECK	12432	MATCH
China	21112	MATCH	13221	MATCH	4543	MATCH
SriLanka	765665	MATCH	3212	MATCH	543543	MATCH
Bhutan	4323	MATCH	32121	MATCH	7686	CHECK
Indonesia	4325	MATCH	123421	MATCH	67566	MATCH
NewZeeland	54325	CHECK	2134	CHECK	564456	CHECK

Compare column by column.xlsx

Alteryx Editions

Accepted answers

Kottapally_Ramesh

Hi Akhilesh,

You can change the settings under the Render tool configuration.

Change Paper size and Margins as per your convenient, you can test run until it matches your expectations.

Another way to do is create a predefined excel file with conditional formatting and load the data into that file.

Kottapally_Ramesh

Hi Akhilesh,

You can add one more column in formula tool as "Overall Status", use the below formula.

IF [Dog_Comparison] = "Check" OR [Cat_Comparision] = "Check" OR [Cow_Comparision]="Check" Then "CHECK" ElseIF [Dog_Comparison]="MATCH" AND [Cat_Comparision]="MATCH" AND [Cow_Comparision]="MATCH" THEN "MATCH" Else "" ENDIF

Accept the solution if it resolves your query.

Final Output:

All comments

Qiu

@akhukla
Could you share what have you completed so far? We can start from their.
I would use the combination of Transpose, Join and CrossTab tools.

akhukla

Hi @QIU, I just started my Altreyx learning journey. depends on the community answer.

Kottapally_Ramesh

Hi,

Check the attached workflow for comparison of two data sets column by column.
you can add/remove the compare column logic in formula tool and change the output path in Render tool.

Compare Column by column.yxmd

akhukla

Hi Ramesh

I can replicate and get the output, but my file format is not as good as yours. Could you Pls guide me how to get the pretty excel output. Thanks for your support.

Kottapally_Ramesh

Hi Akhilesh,

You can change the settings under the Render tool configuration.

CharlieS

Nice workflow, @Kottapally_Ramesh.

@akhukla it looks like you have a lot of columns that are getting squished together in your rendering. The odd way this works is to give the final Render tool a larger canvas to fit those columns into. This is achieved by increasing the Paper Size settings in the Render tool configuration.

Try setting "Paper Size" dropdown to "Custom Size" then in the "Size (in)" boxes for width and height try "25" and "11" (25" wide and 11" tall). The first value controls width, the value you need to increase and have custom control over. The second height value doesn't matter since the Excel file will automatically expand with the data in that dimension.

akhukla

Hi Ramesh, yes, your input really helps me to build the workflow appreciate your quick response.

Will it it be possible to put "CHECK" for the overall row at the 1st column if any of the validation shows as "CHECK"? If yes, what would be workflow? This would be my last question for this thread.

flying008

Hi, @akhukla

If you have more columns to be compare, the below dynamic workflow maybe can help you.

录制_2026_02_06_13_56_23_456.gif

Kottapally_Ramesh

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703