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
Solved! Go to Solution.
Sounds like a Join Multiple tool would work well! Just make sure your data is unique beforehand in each of the five small flows
JOIN multiple will help you to achieve the required
or combination of multiple join and union tools will also work.
Ok, I got it to work. How do I get just the Account and Commodity Columns to show up just once?
See my post below, please.
@tmitchell30 Add a select tool to do so
or use the configuration of the join multiple tool to uncheck the repeated columns
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!
Thank you both so much.