Duplicate output

[DiyaR]

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

[suby]

Hello,

See attached the Workflow if that helps.

Thanks

[DiyaR]

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..

[apathetichell · Accepted solution]

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.

[DiyaR]

OMG!! Bang on!!

I realized my mistake... Thank you so much 🙂

[apathetichell]

We've all been there!