A Unique Lookup allows you to create a match between a recipient's Person Data or One-to-Many Table field and a field in a Global Data Table. This means that you can link recipients to global values such as specifying which product type is a recipient's favourite.
You can also do a Unique One-to-Many Lookup to get values from a specific row in the One-to-many Table. A Unique Lookup will always result in a single match.
In this article, you'll learn how to create a:
- Unique Person Data to Global Data Table Lookup
- Unique One-to-many to Global Data Table Lookup
- Unique One-to-many Lookup
Once you've set up your Unique Lookup, you can merge the result into your communications or use it as a Condition.
How to Create a Unique Person Data to Global Data Table Lookup
- Log in to Staging.
- Open the Data Module and select 'Data Lookups' from the sidebar.
- Click the 'Create' icon in the top toolbar.
- Select 'New Unique Person Data - Global Data Table Lookup'.
- Fill in the name for your new Unique Lookup.
- Click the 'Lookup' panel.
- Select the Person Data you want to match with.
- Select a Global Data Table and a field.
- Select the Global Data Table field to sort the results with and select ascending or descending.
- Click 'Save'.
- You can also add Conditions in the Conditions panel to narrow your results.
Your Unique Person Data to Global Data Table Lookup is now set up and ready for you to merge into communications or to use as a Condition.
A Unique Lookup named 'MY_CANDY_STORE' set to match the Person Data 'FAVORITE_CANDY_STORE' with the Global Data Table field 'STORE.ID'
How to Create a Unique One-to-Many to Global Data Table Lookup
- Log in to Staging.
- Open the Data module and select 'Data Lookups' from the sidebar.
- Click the 'Create' icon in the top toolbar.
- Select 'New Unique One-to-many - Global Data Table Lookup'.
- Fill in a name for your new Unique Lookup.
- Click the 'Lookup' panel.
- Select the One-to-many Table and One-to-many field you want to match with.
- Select a Global Data Table and a field.
- Select the field to sort the results with and select ascending or descending.
- Click 'Save'.
- If you want, you can add Conditions in the Conditions panel to narrow your results.
Your Unique One-to-many to Global Data Table Lookup is now set up and ready for you to merge into communications or to use as a Condition.
A Unique Lookup named 'NEWEST_PURCHASE' set to match the One-to-many field 'PURCHASES.ID' with the Global Data Table field 'PRODUCT.ID'. A Condition is added to make sure the Unique Lookup only returns matches where the purchase has not been returned.
How to Create a Unique One-to-Many Lookup
- Log in to Staging.
- Open the Data module and select 'Data Lookups' from the sidebar.
- Click the 'Create' icon in the top toolbar.
- Select 'New Unique One-to-many Lookup'.
- Fill in a name for your new Unique Lookup.
- Click the 'Lookup' panel.
- Select the One-to-many Table to make your Lookup with.
- Select the One-to-many field to sort on.
- Click 'Save'.
- If you want, you can add Conditions in the Conditions panel to narrow your results.
Your Unique One-to-Many is now set up and ready for you to merge into communications or to use as a Condition.
A Unique Lookup named 'NEWEST_COPENHAGEN_PURCHASE' set to find a row in the PURCHASES One-to-many Table and sort based on PURCHASES.TIME. A Condition is added to make sure the Unique Lookup only returns matches where the purchase been bought in the Copenhagen store.