01-09-2018 08:35 AM - edited 01-09-2018 08:39 AM
The lookup table extension has a Lookup Match -> Output format, but what if I needed to match several variables? Should I use two extensions?
01-10-2018 07:04 AM - last edited on 01-10-2018 08:04 AM by kathleen_jo
01-19-2018 05:25 AM
09-20-2018 05:04 AM
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.
09-21-2018 09:59 AM
In this case, I'd use 2 extensions prior to the lookup table.
What this does is allow you to pre-process using variableA or variableB, yet still do a single lookup table.
09-24-2018 04:23 AM
I still feel this won't be a scalable solution as we will need to add extensions for each variable.
What I feel can be added to the Lookup table is the following-
Look up value in set of variables- Variable a, variable b, variable c, etc and then update myLookup variable if there is a match. This will save time in adding multiple set Data extensions before a Lookup extension.
09-24-2018 07:02 AM - edited 09-24-2018 07:06 AM
You don't need to use multiple extensions for multiple variables. Simply use a single one, and have it set "myVariable" to the following JS code:
b.myVariableA || b.myVariableB || b.myVariableC || b.myVariableD
Chain as many as you need, and the first defined value will be returned. So if you're dealing with naming convention problems across different parts of the site, you might do something like:
Set bestProductName to JSCode: b.productName || b.product_name || b.product
Without intending to be rude, it sounds like the problem isn't the way in which the lookup table extension works, it's the consistency of the data layer that's an issue here. Personally I would use extensions to try to arrive at a consistent data layer prior to performing any lookups, so that all downstream mappings etc. are working to a common definition (after all, the U in UDO stands for universal..).
09-25-2018 01:35 AM
Totally agree about the consistent UDO but I am working on an already existing project and hence have to perform hacks in order for things to work :)
Also, the scope of the values on different pages is different and hence captured in different UDOs depending on page type