Exact Match

Exact match: Link records using exact matching

Exact Match lets you match input data from your current Table with reference data from another Table when the values must be identical.

Use it when your data has a stable shared identifier, such as a SKU, invoice number, SIRET, account code, or customer ID.

How It Works

The tool uses logic to identify exact matches between the input data and a reference dataset stored in another Table.

• You configure a Source Table with clean reference values values to match against.
• You define which column in the Source and which column in your current Table should be compared for matching.

Setting up an exact match

Follow these steps:

1. Create a new column and select Matching as the column type.
2. Select Exact Match as the matching tool.
3. In the column settings, select the Source Table—this is the Phacet that contains your reference data.
4. Choose the session in the Source Table you want to match against.
5. Select the column from the Source Table containing the reference values to match against.
6. Select the input column from your current Table—this is the data you want to match against the reference data.
7. Click Save and Update to run the matching process.

Reviewing Results

Once generated, the Matching column will display the number of matched values found in the Source Table.

If no match is found, the column will return “No match found”

Tip: Accessing matched data

You can create a Text Column and use a Python function to display the information related to the matched item on the Source Table.

The output will be an array containing all columns names and raw values.

Use the example code below

#---- PARAMS -----#
#example_param = @example_column
#---- END PARAMS -----#

#---- MAIN FUNCTION ----#
def main():
  return @matching_column_name
#---- END MAIN FUNCTION ----#

### Replace matching_column_name by the name of the column where