The purpose of the Lookup Table Extension is to look for a certain value in one Variable (formerly Data Source) and replace it with another value or set the new value in another Variable, depending on what you specify in the Lookup Table. You can use this to change numeric information like product IDs into a readable identifier, such as a product description.
How Default Output works
The Default Output takes effect only when the lookup match has failed and the disable box is unchecked. This table explains how the Destination changes in relation to the Variables and the default value .
|Default Output is populated||Default Output is blank|
|Lookup and Destination are unique||Destination value is replaced by the default value||Destination value is left blank|
|Lookup and Destination are identical||Both Lookup and Destination values are replaced by the default value||Lookup and Destination values are NOT replaced.|
You can enter large numbers of Lookups with the 'Import from CSV' feature. Enter the CSV (comma-separated value) formatted text in the order of Lookup value, Output value and corresponding notes. The lookup value is entered into the Lookup Match field and the corresponding output value is entered into the Destination field.
One example of a Lookup-Output value pair is product IDs linked to product names. A product might have an ID of "123" and a name of "LED TV". Another product might have and ID of "789" and a name of "Plasma TV". In both these situations, the value of the Lookup-Output pair is the product's ID, while the value of the Lookup-Output pair is the English-readable name of the product.
To add Lookup-Output values in bulk:
This feature exports the lookup values into a .CSV file. Enter the values for Lookup Match, Output, and Notes in their respective fields and click the 'Export to CSV' button. At least one instance of lookup match, output, and note value is required to perform a successful export. If all the three lookup fields are blank, no data will be exported.
NOTE: This feature is compatible with most modern browsers, with the exception of IE. If you are using Firefox or Chrome, the values are directly exported into a 'lookup.csv' file. In a Safari browser, the CSV-formatted values are exported into a new browser tab instead of a .CSV file.
You have a list of product IDs in your system. However, you find that looking at product ID numbers gives you a headache. When you look at the ID number, you don't immediately know if it corresponds to a Blue-ray player or a bag of kitty litter. The Lookup Table Extension allows you to match a readable value, such as a product's name, to that product's ID number.
Add more Lookups, matching the product ID "456" to "Sony Blue-ray Player" and "789" to "Panasonic Plasma TV". Add relevant notes for the lookups.
Now, when the Lookup Table Extension runs, it will look for the product IDs in the product-Id variable and populate the product_name variable with the corresponding product name.