Lookup tables is used in data mappings to automatically translate values for one resource to another. You can skip this article if you don't intend to create custom data mapping.
For example, Mailchimp Subscriber Status supports the following values:
- archived
- transactional
- pending
- cleaned
- unsubscribed
- subscribed
OnVoard Contact Email Unsubscribed is a boolean field and only supports:
- true
- false
Mailchimp Subscriber Status |
OnVoard Contact Email Unsubscribed |
archived |
true |
transactional |
false |
pending | false |
cleaned | true |
unsubscribed | true |
subscribed | false |
Since the values can't be directly mapped, we can use lookup table to translate values.
Lookup Tables in Data Mapping
Here's a screenshot demo on how lookup table is used in formula step for Mailchimp Subscriber to OnVoard Contact data mapping.