Prior to this task:
✔ Data canvas must be opened.
✔ New columns must be added to a data table.
|
1️⃣ Data canvas ➡ Data tables ➡ select "data table name" |
|
|
2️⃣ Data canvas ➡ select |
|
|
3️⃣ Settings for added columns window ➡ select Match columns ➡ select/deselect column(s) accordingly |
|
|
4️⃣ Settings for added columns window ➡ select Columns from new data ➡ select/deselect column(s) accordingly |
|
|
5️⃣ Settings for added columns window ➡ select Join settings ➡ select join |
|
|
6️⃣ Settings for added columns window ➡ select |
Supporting Knowledge
From the Join settings dropdown, review the interactive join example for information about how rows will be matched according to the join type.
➡ Left outer join: Rows from original data only.
➡ Left single match join: Rows from original data only, single match from new.
➡ Full outer join: All rows, from both original and new data.
➡ Inner join: Rows matching in both original and new data only.
➡ Right outer join: Rows from new data only.
➡ Right single match join: Rows from new data only, single match from original.
Note: The user can specify to match empty values or not using the Treat empty values as equal checkbox.