Combine Data Excel

maddoxs

Hello all 

I am needing assistance on combining data from two separate spreadsheets based off one column (Sales Order) into one output excel

Basically, if the sales orders match on both spreadsheets, can I add columns from the other input based off that match into one spreadsheet

Thank you!! 

gabrielvilella

I believe you want to use the Join tool, similar to a VLOOKUP in Excel. 

See here how to use the tool: https://community.alteryx.com/t5/Interactive-Lessons/Joining-Data/ta-p/76634