Definition
A match table is composed of 2 columns: Key, standing for the IN value to check, and Value, standing for the associated value when OUT.
Creation
To create a match table, you can go to Data Management > Configuration > Match tables and click on the “+” button on the bottom-right corner. You can then name it and specify if its keys are case-sensitive or not.
Edition
To fill in the matches, you can rely on 2 ways:
- Add a line (easy for a quick edition)
- Import a CSV file (helpful for a massive mapping addition)
Note: The CSV file must contain as many lines as Key;Value pairs (with the separator ";" between Key and Value). Up to 10,000 lines per file, and a match table can contain 50,000 lines maximum.
- If a key already exists, the value will be replaced by the value present in the file
- If a key does not exist, it will be created
- If a key is already present in the match table, but not present in the file, it will be conserved
Once your line is added, you can edit it at anytime by clicking on the steering wheel at the end of the line, or delete the line by clicking on the bin icon.
You can change the name of the table by going to the metadata tab.
Use
A matching table can be used:
- In a property rule based on the action Replace > Match table
- In an exclusion, based on a snippet
You will be able to see where your match table is used thanks to the "Properties" and "Exclusions" columns.
Deletion
You can delete the matching table of your choice if it is not used in any rule.
Otherwise, you need to withdraw the matching table from the rule first before deleting it.