...
We should always change the default name to something more meaningful using the Rename Lookup option:
...
Info
The data lookup name can be any combination of letters, numbers, spaces and special characters. Both upper and lower case characters can be used.
Unlike our other data lookups, there is only one table that contains our product competition data. Therefore, renaming of this data lookup would be to save specific types of search conditions. For example, if our lookup was based on specific competitor name:
...
The default Price Parameter set of visual blocks will be created and our initial step will be to select our Price Parameter table from the list of tables:
...
...
The table names that are listed in this list will be the Labels associated with our tables and not the actual table names.
Once the table has been selected, then the set of attribute filters will be displayed for this table:
...
The number of attributes filter shown can be linked to the key fields for our table. For example, for the Cost Plus Factor table it has three key fields and they are shown as our filter attributes.
...
...
Price Parameter tables that can have multiple key fields are known as MATRIX type tables and the maximum number of key fields allowable is 6.
Live Preview
The Live Preview option for Price Parameter data lookups will display all of the rows that match our search filters and also display the Value that is being returned for the attribute selected. Additionally, it provides a drop-down to allow us to select different product sku values:
...
...
In this example, we are returning multiple result rows since not all of the search filters are used, to return a single unique role we would need to supply values for Industry, BusinessUnit, and product_group_category.