Join for a beginner

[remibrun]

Hi everybody,

new user on alteryx, I try to combine two data sets with a join tool. The problem is that after that, I have 2 ou 3 times records more.

I combine with one field because I have juste one field in common.

I post my workflow iff you have any suggestion.

Sorry my question is maybe very simple...

Thanks

[danespoors · Accepted solution]

The unique tool allows you to select for all of the unique CNK values so if a value appears once, it will appear and if it appears 1000 times, it will appear. It will select all of the unique CNK values no matter how many times they appear which is essentially what a group by tool would do but this way you don't lose the rest of your data.

I'd advise the unique tool as in SQL terminology, this is essentially running a SELECT DISTINCT and returning unique values.

Hope that helps,

Dane.

[remibrun]

Thanks everybody for your help. My flow is working!