Joins are used to augment the information contained in one table with the data contained in another table.
Two tables can be joined when they both have at least one column sharing identical values.
- Select the tabs you want to join to the current tab. To add data to a new table, use an Add data step or a Scrape step. You can also import data from another tab using the Start from tab step.
- Select at least one shared column between the two tabs. Columns need to have with identical names in both tabs to appear in the column selector. Rename them with matching names to get them to appear.
- Select the columns you want to bring into the current tab.
Tab 1 and 2 below share the column
First name . Each table contain one other column of data associated with the values in
First name .
When joining Tab 1 with Tab 2 on
First name , values in that column are matched, and corresponding values from the other tab are appended.
Select all records from Table A, along with records from Table B for which the join condition is met (if at all).
Select all records from Table A and Table B, where the join condition is met.
Select all records from Table B, along with records from Table A for which the join condition is met (if at all).