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 next

...

In the next step, you specify the type of join and one or more join keys.Image Added

Image Removed

D caption
Specify join type and join keys.

...

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.

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.

Join Key Summary:

You can use these metrics to identify the likelihood of accurate matching between the join keys and the row count generated in the output.

...