.svg?alt=media&token=086e62cd-7fd3-4d25-8ce7-fa5613a9f9e2)
Comment on page
Cross-reference lookups
Cross-reference lookups are used for cases where sets of static values are commonly known by another value. For example:
Weight measurements
Term | Also known as... |
|---|---|
Kilogram | Kg |
Gram | g |
Cup | c |
Months of the year
Term | Also known as... |
|---|---|
January | Jan |
February | Feb |
March | Mar |
If you have source data which includes values that always need to be changed to an alternative term, a cross-reference lookup can be used to transform required data fields.
For example, you might have an incoming payload which has a 'renewal month' field with values in the form 'January', 'February', 'March', etc. but also have a target connection which only accepts months in abbreviated form - 'Jan', 'Feb', 'Mar', etc.
In this scenario, you could add 12
replace transformation functions for any field that needs this conversion - but a more efficient approach is to add one map transformation function (associated with the appropriate cross-reference lookup) to required fields.If required, cross-reference lookups can also be updated via the Patchworks API. For more information please see our Cross-reference lookup API section.