We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

JOIN BASED ON CODE

nirvapatel1998
7 - Meteor

Hi All. I am trying to join the two excel sheets based on the Code. Any suggestions. My output should show code and total from both. I need another output that shows Code, All the total numbers from Book1 and Book2. I am attaching sample output as well in the excel form for reference. Thank you in advance. 

1 REPLY 1
DataNath
16 - Nebula

How does this look, @nirvapatel1998? You can just use the Summarize tool to get the Totals for each code, before joining it back to the main dataset and cleaning it up to match your desired outputs with a Multi-Row Formula. All you'll need to do is replace the Browse tools I've added with Output Data tools if you want them as separate outputs:

 

DataNath_0-1660142048895.pngDataNath_1-1660142064007.png

Labels