JOIN BASED ON CODE

Question

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.

Book2.xlsx

Book3.xlsx

Book1.xlsx

DataNath · Answer

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:

Totals based on Code.yxmd