Match Type options are additional mapping options that enhance the flexibility of scanning the mapped tables. Match Type options define a search pattern for the different roles and broaden the system’s ability to extract the desired table even if elements in this table have changed.
The “Match Type” option enables the tool/table to capture cell values that are not quietly the same.
“Match Types” arguments, listed from least to most flexible search types:
- Value – The expected value will be exactly the same as the value of the cell that was mapped.
- List – In case you have a variation in one of the cell’s values between different version of your file, you can create a list of acceptable values.
- Example: The header’s value in this version of the table, located in cell B1, is “Account”. However, in other versions of the file this cell’s value can have a slight variation in value (e.g. lower-case letters: “account”). Choosing Match Type: List, then insert a list of acceptable values for this header. It will allow the following/previous versions to be extracted successfully as well.
- Location – Use this option when the cell value changes (or might change) throughout versions, but the location of the cell stays the same.
- Example: The cell's value is a date that changes daily/every version, but its location stays the same.
- Regex – Extract values based on a textual or numerical pattern. Regex is a textual syntax for representing patterns for matching text.
- Clicking on Suggest will assist you to write a valid regex pattern or contact your Success Manager for further assistance.