Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r081

D toc

Excerpt

In the Join window of

...

the 

D s webapp
rtrue
, you can join your current dataset with another dataset or recipe based upon information that is common to both datasets.

For example, you could join together two sets of regional sales data based upon the product identifiers that they both use to track sales. In the Search panel, enter join datasets or select the Join icon from the toolbar.

...

In the Search panel, enter join datasets.

Browse dataset and recipe list

Select Then, select the dataset or recipe that you wish to join with your current dataset.

...

  • Use the Search bar to locate specific objects.
  • Click Accept.To browse objects in the current flow, click Browse current flow. See below.

Browse current flow

You can limit your review of the objects to browse to those in the current flow.

Image Removed

D caption
Browse current flow
  1. Select the dataset or recipe to join in.
  2. Click the Data or Recipe tab to preview the data in the selected object.
  3. To begin joining with the selected object, click Accept.

Step 2 - Select Join Conditions

...

D caption
Specify join type and join keys

Dataset samples:

Mouse over the Dataset samples indicator to see the current samples from the datasets that are part of the join. For more information, see Samples Panel.

Join type:

From the drop-down, select the type of join to apply. For more information, see Join Types.

...

From the selected datasets, you can specify the columns to include in the output.

 

D caption
Select output columns

...