Reply
Highlighted
Visitor
Posts: 4
Registered: ‎12-11-2017

Lookup table with multiple criteria

[ Edited ]

The lookup table extension has a Lookup Match -> Output format, but what if I needed to match several variables? Should I use two extensions?

Employee Emeritus
Posts: 44
Registered: ‎02-28-2016

Re: Lookup table with multiple criteria

[ Edited ]

Hello @isaacc. If you have a set of variables that you need to combine, and then use to match. Use the Join Data Values extension ahead of the lookup table, and then match on the joined variable value(s).

Tealium Employee
Posts: 380
Registered: ‎09-01-2015

Re: Lookup table with multiple criteria

Hi @isaacc

I would post this into the new Product Ideas forum.
This is a perfect candidate.

Regards,

Adrian

Ask me anything Tealium related or Javascript, or NodeJS. But not cooking, can't do that.
Please remember to mark solutions as accepted for future searchers.
Visitor
Posts: 10
Registered: ‎06-21-2017

Re: Lookup table with multiple criteria

I have a similar situation where I have to look up for a value in multiple variables. It might be present in variable1 on certain pages and in variable2 for certain pages. 

Irrespective of where the value was, I want to assign that value to a new UDO using look up table. This is currently not possible.

Reply
0 Kudos
Tealium Employee
Posts: 740
Registered: ‎09-01-2015

Re: Lookup table with multiple criteria

@ksugam

In this case, I'd use 2 extensions prior to the lookup table.

  1. Create a new data attribute, e.g. myLookup
  2. Create a new Set Data Values extension that sets myLookup to variableA if variableA exists
  3. Create a new Set Data Values extension that sets myLookup to variableB if myLookup is not defined and is not populated, and if variableB exists (this ignores using variableB so that variableA takes precedence, but you can setup up the condition how you like)
  4. Then do the lookup extension that looks up against myLookup

What this does is allow you to pre-process using variableA or variableB, yet still do a single lookup table. 

Cheers,
-Dan

Reply
0 Kudos