Combining 2 tables/ Merging 2 tables

[inarayanan]

Can someone help with the below? I am looking for a tool to combine 2 tables as one and also perform somewhat a vlookup. While using the Join tool, it takes only the common values from the field to combine the table. For example - from the below table since values B, D, E and F are not in both tables, the combined table using Join tool only combines the output table for A, C

[Luke_C · Accepted solution]

Hi @inarayanan 

You would want to join on Name, then union all three output anchors of the join tool

[KarolinaRoza · Accepted solution]

Hi,

See attached workflow.

[inarayanan]

Thank you, the solutions work!