...
This refers to the type of Filter that will be used for our data lookup. Our options are ALL (returned rows meet all conditions) or ANY (returned rows meet any conditions).
Identifies all of our conditional filters that can be used to define the search for our data lookup. One or more conditions can be defined.
Will set which sequence of result values we would like to return
...
NOTE: Unlike our other data lookups, we don’t need to specify the name of our table since there is only one data table that contains our competition data.
ALL or ANY
Our competition data lookup will involve one or more conditional clauses and our filter option will determine how they are used with our search query:
...
When our search conditions contain more than one filter operation, then the ANY option means that competition data will be returned that meets ANY of our conditions. At least one of the conditions must be true for competition data to be returned. This allows conditions to operate as an OR operation.
...
NOTE: Multiple conditional operations can be defined by using the Filters option on the Data Lookups panel. It provides option for a single condition or multiple conditions.
Filter Operations
With the Competition Data Lookup, we have the ability to create multiple search conditionals and even pair them together into AND and OR combinations. Each filter operation is comprised of these elements; target attribute, relational operator and comparison value.
...
3. Comparison value, displays the numeric or character value that will be used for our filter comparison.
Live Preview
The Live Preview will contain both the set of rows from the competition table and the results data lookup based on your search criteria. In the following example, we are using ALL option, filtering on product A9N17518 and seeking Average of all competition. Therefore, out Live Preview panel will appear as:
...
We can search on numeric values, with their associated relational operators, and we can combine them with the product sku filter on the Live Preview panel:
...
NOTE: The result data shown in Source Data reflects the impact of our filter on Price and it is combined with the product SKU of A9N17518. The result value of 56 will then reflect the Highest value.