How do I Join 5 Inputs with 2 alike columns? I need the acct and commodity col listed once

[tmitchell30]

I have 5 workflows (ex. 2 below with a different 3rd column) and I need them to join by account and commodity columns. All 5 have a different third column that need to stack next to the like account and commodity column.

LOOK Li 

 

[alexnajm]

Sounds like a Join Multiple tool would work well! Just make sure your data is unique beforehand in each of the five small flows

[Raj]

JOIN multiple will help you to achieve the required
or combination of multiple join and union tools will also work.

[tmitchell30]

Ok, I got it to work. How do I get just the Account and Commodity Columns to show up just once?

 

[tmitchell30]

See my post below, please.

[Raj · Accepted solution]

@tmitchell30 Add a select tool to do so
or use the configuration of the join multiple tool to uncheck the repeated columns

[alexnajm · Accepted solution]

You go into the Join Multiple tool and deselect the columns you don’t want. 

However, if you need to bring values over from a column, you might need to do some sort of Formula to get the right values, then use a Select to remove the extra columns. 

Either way you have options!

[tmitchell30]

Thank you both so much.