| D toc |
|---|
| Excerpt |
|---|
In the Join window of |
...
the
|
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.
...
| 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.
Join keys:
In the above image, the platform has determined that the item number (Item_Nbr) field of Region 1 data and the item number (ITEM_NBR) field from REF_PROD should be used as the keys for performing the join.
...
| Option | Description | ||||
|---|---|---|---|---|---|
| fuzzy match | Use a fuzzy matching algorithm for key value matching.
Fuzzy matching uses the doublemetaphone algorithm for matching strings (keys). Both primary encodings of each key value must match. See DOUBLEMETAPHONEEQUALS Function. | ||||
| Ignore case | Ignore case differences between the join key values for matching purposes. | ||||
| Ignore special characters | Ignore all characters that are not alphanumeric, accented Latin characters, or whitespace, prior to testing for a match. | ||||
| Ignore whitespace | Ignore all whitespace characters, including spaces, tabs, carriage returns, and newlines. |
...
To add the specified join to your recipe, click Add to Recipe.
| D s also | ||
|---|---|---|
|
