Skip to main content

Varicent ELT Assistant

Combination Matcher

Use the Combination Matcher tool to compare two data sets to find matching values. Identifies if records from one data set match the approved combinations defined in the rule data set. 

Input and output

This tool takes two data sets. You can select the data source with the combinations to be used for matching, and this is the data Varicent ELT will use to match and join the two data sets.

When configuring the tool, you can choose which Match type you want to use:

  • Exact match: Use when you want to check for exact value matches. This is the default choice.

  • Contains: Use when you want to check that a text value in the Combination column contains a text value in the Match column.

  • Is Contained In: Use when you want to check that a text value in the Combination column is contained within a text value in the Match column.

Note

You can only use match types Contains and Is Contained In when the Combination and Match columns are both a text type.

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.

Configuration

Use the following configuration options to configure the Combination Matcher tool.

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the Tools modal, search for Combination Matcher , and then click + Add tool.

    Note

    You can also find the Combination Matcher tool in the Combine section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, in the Target section, under Combination sources, select which data source to compare against to determine exact matches.

  8. Under ID column, optionally select the column to use as the ID column.

  9. Under Matched column name, enter the name for the matched column name.

  10. Under Matched ID column name, enter the name for the matched ID column name.

  11. In the Match 1 section, under Combination column, select the column to use for the combination column.

  12. Under Match type, select the match type:

    • Exact match

    • Contains

    • Is contained in

  13. Under Match column, select the column to use for the match.

  14. Optionally, click + New match column to create another match.

  15. Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.

  16. Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.

Usage example

Let's say you have two data sets. The first contains a list of online t-shirt orders, and the other contains the season's collections.

Using the Combination Matcher tool, you can identify the orders you can fulfill based on the matched values between the two data sets, such as the t-shirt color and size.