Help appending a column from one workbook into another

[svargas01]

I am really new to alteryx and am trying to learn; but do not have all the vocab down yet, so I apologize if this is unclear:

I have 1 main source of excel data, and 3 additional that I am pulling one or two columns of information from (think xlookup in excel). I am trying to do pull one column from source 2 into source one, keeping all data from source one and adding one column from source 2 to match on a field "person number". I was hoping to get any lines from source 2 to populate at the end of source one in a new column, and if there was no match for "person number" the field would be blank. I am not able to share the source files, but was hoping for some assistance. I am happy to answer any questions and appreciate any feedback/assistance!

[TimN · Accepted solution]

Maybe something like this.  You can add on additional data sources...

[svargas01]

Thank you so much! This worked exactly how I needed.