While syndicating a product, it may become necessary for a user to apply transformations to meet channel-specific requirements. While value transformations can be applied in different ways, one standard method to apply value transformation is through Lookup Tables.
The 'Lookup tables' tab page within the Settings screen allows users to upload a Transformation Lookup Table file which can be used to apply value transformations when necessary. Below is the screenshot of the 'Lookup tables' tab page when no file is uploaded.
The 'Lookup tables' tab page comprises a clickable link that allows users to upload a lookup table file and the following five columns that display the details of the uploaded lookup table file.
-
Name: This column displays the name of the lookup table. If multiple sheets are within the uploaded lookup table file, the channel creates a separate lookup table for each sheet. The naming of the lookup tables displayed in the application will be identical to the naming of the sheets within the uploaded lookup table file.
-
Origin file: Displays the original name of the lookup table file.
-
Rows: This column displays the number of 'before-and-after-value' sets within the uploaded sheet.
-
Last Updated: This column displays the date and time of the current file upload.
-
Actions: This column contains a delete icon (
) that, when clicked, will initiate the delete process of the uploaded lookup table file. Further, a dialog confirming the delete action will be displayed when a lookup table file is initiated for deletion, as shown below. Users must select the 'Yes, I want to delete this lookup table' check box and then click on the Delete button (which will be activated upon selecting the checkbox) to remove the file from the channel.
The lookup table allows users to change multiple instances of a value for an attribute. Users need an Excel file containing the old and new values to do this. To create a Transformation Lookup Table file that contains the old value and new value, do the following:
-
Create two columns to contain the old and new values. In the example below, the columns have been named 'Old' and 'New,' but there is no naming rule for the columns. Although the example shown contains only one value transformation, multiple old and new value sets can be identified for value transformation in the column.
-
Name the tab containing the values an identifiable name.
-
Save the spreadsheet with the name of choice. The example below has been named 'Lookup table.'
The created lookup table file can be uploaded by clicking the 
link available at the top right of the 'Lookup tables' tab page. Below is the screenshot of the 'Lookup tables' tab page displayed when configured with a lookup table file:
Once the file is uploaded, the 'Publish' button should be clicked to make the values available to use for transformations in the channel.
Note: The 'Publish' action is only necessary in configured channels. Direct channels will have the table immediately available after upload, and no 'Publish' button will be shown.