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.

...

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.

...

OptionDescription
fuzzy match

Use a fuzzy matching algorithm for key value matching.

Tip

Tip: Use this option to perform fuzzy join matching of primary keys between datasets.


Info

NOTE: Fuzzy joins can only be applied to String data types. Other data types cannot be fuzzy-matched using the algorithm.

Fuzzy matching uses the doublemetaphone algorithm for matching strings (keys). Both primary encodings of each key value must match. See DOUBLEMETAPHONEEQUALS Function.

Ignore caseIgnore case differences between the join key values for matching purposes.
Ignore special charactersIgnore all characters that are not alphanumeric, accented Latin characters, or whitespace, prior to testing for a match.
Ignore whitespaceIgnore all whitespace characters, including spaces, tabs, carriage returns, and newlines.

...