Is it possible to match to partial values instead of an exact match in a lookup table?

[InvocaKnowledge]

Question Variations

• Is it possible to use wildcards in a lookup table?
• How do wildcards work in a lookup table?

Applies To

• Lookup tables
• Customer package includes lookup table functionality

Answer

Lookup tables can use wildcard functionality in the primary key only (column A), not the secondary key.   

Wildcard is represented with an *

Capable of only being applied to prefixes and not as a standalone *

Additional Information

• Lookup table evaluates from top to bottom.  If wildcard(s) and more specific key values are used in combination, the wildcard(s) should be at the top of the lookup table.
• Example - to apply a wildcard for values for domains (www.invoca.com, www.invoca.com/product, www.invoca.com/team), you can simply put one value: www.invoca.com*