Hello community, I have two datasets that look like below. Can you suggest the best way to do a one is to one comparison and identify the differences and maybe a new column which shows if the row is a Match across the other dataset. Book Number/Store Code10111012ABC12310.5DEF123 2GHI1231 Book Number/Store Code10111012ABC123 0.5DEF123 2GHI123 2 Expected Output Book Number/Store Code10111012New_Book Number/Store CodeNew_1011New_1012Match?ABC12310.5ABC123 0.5NoDEF123 2DEF123 2YesGHI1231 GHI123 2No I am thinking of achieving it this way, do you think this is something that might work or if there is a better way of doing it? Thank you

Compare two datasets similar to a matrix

Hello community,

I have two datasets that look like below. Can you suggest the best way to do a one is to one comparison and identify the differences and maybe a new column which shows if the row is a Match across the other dataset.

Book Number/Store Code	1011	1012
ABC123	1	0.5
DEF123		2
GHI123	1

Book Number/Store Code	1011	1012
ABC123		0.5
DEF123		2
GHI123		2

Expected Output

Book Number/Store Code	1011	1012	New_Book Number/Store Code	New_1011	New_1012	Match?
ABC123	1	0.5	ABC123		0.5	No
DEF123		2	DEF123		2	Yes
GHI123	1		GHI123		2	No

I am thinking of achieving it this way, do you think this is something that might work or if there is a better way of doing it?

Thank you

Workflow

Accepted answers

Verakso

I saw something like this in another post, perhaps it could help you on

2024-05-23 21_43_18-Alteryx Designer x64 - Compare Tables.yxmd.png

Br (ツ)

Thomas

Compare Tables.yxmd

Raj

@ssripat3 the added method will work for N number of tables.

mark solutions done if solved

1150.yxmd

try this

All comments

Verakso

I saw something like this in another post, perhaps it could help you on

2024-05-23 21_43_18-Alteryx Designer x64 - Compare Tables.yxmd.png

Br (ツ)

Thomas

Compare Tables.yxmd

Raj

@ssripat3
find the workflow attached hope this helps.

1145.yxmd

ssripat3

Hello @Raj . Thank you for the solution and sorry for not explaining my real data. My dataset has around 200 columns with Store Code. In this scenario, what would be an ideal solution to compare?

Raj

@ssripat3 Can you please add some sample data for better understanding.

Raj

@ssripat3 the added method will work for N number of tables.

mark solutions done if solved

1150.yxmd

try this

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15873

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703