When you create a transformation view, you must select a data source to be your primary dataset. To associate additional columns that come from other datasets, join additional data sources to the transformation view. You can also apply a union to permit additional rows to be added.
Add a data source and apply a join
You can apply an inner join or lookup join to combine values from two datasets. An inner join keeps rows with matching values. A lookup join keeps all values in a dataset.
To add a data source and apply a join:
- Select Data Orchestrator from the top-left navigation menu.
- Select Transformation views from the left-side panel.
- Open a transformation view from the list.
- Select Data sources .
- Select Add data source from the Data sources panel on the right.
- Select Join.
- On the Choose a dataset pane, select a dataset and then select Next.
- On the Select Join keys page:
- Select the Join type:
- Inner join: This option keeps all the rows that have values that match in the two datasets.
- Lookup: This option keeps all the rows from the primary dataset, and adds columns from the joined dataset. If the joined dataset has no rows that match, the column values are NULL.
- From the Join with columns dropdowns, select the columns that you want to match with the source data columns.
- Select Next.
- Select the Join type:
- On the Source columns pane:
- Select the source columns you want to include in your transformation view.
- Select Add.
The data source is added to the Data source panel.
You can include additional columns from the joined data sources one at a time. To do this, find the data source in the Data sources panel on the right, and then select add icon next to the columns you want to add.
Add a data source and apply a union
You can apply a union to combine values from two datasets. Union removes duplicate values from the datasets.
To add a data source and apply a union:
- Select Data Orchestrator from the top-left navigation menu.
- Select Transformation views from the left-side panel.
- Open a transformation view from the list.
- Select Data sources .
- Select Add data source from the Data sources panel on the right.
- Select Union.
- On the Choose a dataset pane, select a dataset then select Next.
- On the Map columns pane, perform these steps:
- From the Union with columns dropdowns, select the columns that you want to be in a union with the source data columns.
- To find a source data column, enter a search term in the Find columns field.
- Select Add.
The data source is added to the Data source panel.