Home / 

Mappings: Use wildcards in Lookup TablesAugust 30, 2022

If you receive data which contains a certain string but has a range of available prefixes or suffixes, and you need to map it to a reduced set of target values, you can use Lookup Tables with wildcards to match multiple possible input options at once. Simply replace the interchangeable part of the key with * symbol. Follow a step-by-step guide here.