07 Join and Concatenate - Solution

Solution to an exercise for joining and concatenating data.

Combine data tables side-by-side using the join operation. Put tables on top of each other with the concatenate operation.

CHECK YOUR ANSWERS:

Joiner:
The number of rows is 32549 in all joined tables. No rows were discarded in the joining operations.

Concatenate:
The ID column is missing in the adult_scotland table. You need to select union of columns, if you want to include the ID column in the concatenated table.

External resources

• Joining Data Tables Part I: Inner Join
• Joining Data Tables
• Concatenate: Piling up Data Tables
• Concatenate: Concatenate node
• Joining Data Tables Part II: Left Outer Join, Right Outer Join, Full Outer Join