Compare two datasets similar to a matrix

[ssripat3]

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

[Verakso · Accepted solution]

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

Br (ツ)

Thomas

[Raj]

@ssripat3 
find the workflow attached hope this helps.

[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 · Accepted solution]

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

mark solutions done if solved

[muhammad_bhatti · Accepted solution]

try this