Join Duplicates query/mismatching

Question

Hello,

I want to find the discrepancies' between two sets of data. I have an issue where I have rows of data for the same Unique Identifier, I need to determine where one data set has more rows than the other. I know my example has 2 rows from one source and 3 from the other. Alteryx is duplicating my two matches up to 6 rows, matching to the same unique ID or matching all three rows, when there is only 2 rows.

I have attached the sample data, I have tried to join on the unique identifiers and created unique IDs.

Please help, thanks Leigh

Alteryx Comparison example.xlsx

Bmthred1980 · Answer

Thanks, I have created unique IDs for both sets of data but I haven't work out how to filter or select the right options to reflect the correct matches?

apathetichell · Answer

That is how join works. if you are matching on non unique identifiers - each match creates a new row. this is a standard SQL join.