Skip to main content

Varicent ELT Help Center

Combination Matcher

Abstract

Identify if records from one data set match the approved combinations defined in the rule data set.

The Combination Matcher tool identifies if records from one data set match the approved combinations defined in the rule data set.

In this example, let's compare a list of t-shirt orders Combo Matcher Transactions (Data) to types of t-shirts available this season Combo Matcher Combinations (Data). We will then filter the matches to only view the orders that could be fulfilled for this season.

Parameters

  1. Combination source: Select the answer key data set containing the combinations to be used for matching.

  2. ID column (optional): Select the ID column from the Combination source if the column is available.

  3. Matched column name: This names the column indicating if the record matches any combination. By default, this column name is "Matched".

  4. Matched ID column name: This names the column indicating the combination ID when one record matches one combination. By default, this column name is "MatchID".

  5. Match 1, 2, 3...etc.: This specifies the columns from each data set that are used for matching.

Output

The output contains all records from the data set, plus an additional column indicating if one record matches any combination. The value will be "True" or "False".

When the ID Column is selected, an additional column will display the combination ID when a record matches a combination. If the record does not match any combination, the value will be empty.