...
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.
| Info | |
|---|---|
NOTE: By default,
|
- To make changes to the two join keys, mouse over the specified keys:
- To remove the two columns as join keys, click the X icon.
- To edit the keys to use and other key options, click the Pencil icon. See below.
To add more join keys, click Add.
Info NOTE: Be careful applying multiple join keys. Depending on the join type, this type of join can greatly expand the size of the generated data.
...
| 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. |
...
From the selected datasets, you can specify the columns to include in the output.
| D caption |
|---|
Select output columns |
...
