Duplicate output
- 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,
I am struggling here, please help!!
I had more than 3 inputs, I used Join multiple tool. However, my totals seems to be duplicated. I have attached excel spreadsheet as a sample. Thank you
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for your help..
My apologies, I think I didn't do good job in explaining what I am doing. My three inputs are already joined via Multiple join. When flows run it duplicates some records..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you are not joining on enough columns - Alteryx can't make a decision about which piece of secondary data should be joined to which piece of secondary data so instead of assuming there is a match it creates a duplicate entry. You can fix this by joining more colums - i.e. ID and Account or something like that.
If you need more help - post sample data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
OMG!! Bang on!!
I realized my mistake... Thank you so much 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We've all been there!
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)