Finding Differences based on common group avoiding cross join

nirvapatel1998

Hi all.

In the attached sheet, I need to find the difference between two sheet values avoiding cross join on it. My sheet one and two are input and my sheet three is output. I need to do my join only on group and get the output shown in the Output sheet(Attached excel). I tried doing it but it is doing cross join for me in group. I need some suggestion to solve this challenge. Thank you in advance.

Finding values.xlsx

Common Use Cases

Join

Accepted answers

All comments

philipmannering

In the Join Tool, you can select Join on Record Position. Would this be a solution?

MarqueeCrew

@nirvapatel1998 ,

The trick that I saw was to add a GROUPED record ID to identify the row# of each record in File 2. If the rows match identically, then you can JOIN on record position. In the example, that is TRUE. so you can simply JOIN on record position and get to your result.

Cheers,

Mark

nirvapatel1998

Sorry, I forgot to add some extra values in sheet two. I tried your approach but there are extra group in sheet two.

nirvapatel1998

Can you please explain it in little details. Thank you

binu_acs

@nirvapatel1998 another way of doing this with the help of Tile and the Join tool to avoid cross join

Difference_0817.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703