Adding a column from a different input file

Floris77

Hi,

I was wondering how I can add a column from a different input file to the main file. Problem I'm facing; the second input field does not contain ALL combining fiields as the main file.

Example.

File 1

Name     City

Scott       Amsterdam

Eric         New York

John       London

File 2

Name     Phone

Scott      +31123456789

So, how can I add the column 'Phone' in file 1, and showing no phone number for the rows not mentioned in File 2 (as shown below)

Name     City               Phone

Scott       Amsterdam   +31123456789

Eric         New York

John       London

I tried it with the Join and Union function, but that will only show the name with the phone number, not the ones without.

Thanks a lot,

Floris

jdunkerley79

A Join (on Name) followed by a Union (taking the L(eft) and J(oin) outputs) should do what you need.

Only issue I could think of is if you have trailing spaces on one of the inputs such that the Names arent equal. In which case you will need to use a formula tool to tidy a little first.

Sample workflow attached.

Join and Union.yxmd