Using Join

[ll98]

Hi Alteryx 

I'm having issues joining two data sets --- the output is just producing the one that match only ---- I would like to show all the columns although. I attached how the File should look at the end..

[IraWatt · Accepted solution]

Hey @ll98,

Think this is the setup your looking for:

[IraWatt · Accepted solution]

@ll98 The union tool allows you to append the left right and centre joins on top of each other creating the setup you want. I also removed the duplicated columns from the centre join.

[ll98 · Accepted solution]

@IraWatt   Thanks Ira ..... This really help 

[IraWatt]

No worries @ll98 :)