Spotfire: Edit settings for added columns from the Data canvas

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  [Edit settings for added columns]
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 [OK]

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.