Join for a beginner
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks everybody for your help. My flow is working!
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)
- « Previous
-
- 1
- 2
- Next »