Cross-reference lookups
Introduction
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.
Patchworks provides a range of cross-reference lookups which you can install and use, or you can add your own.
In this section
If required, cross-reference lookups can also be updated via the Patchworks API. For more information please see our Cross-reference lookup API section.
Last updated