- TLC Home Home
- Discussions Discussions
- Documentation Documentation
- Knowledge Base Knowledge Base
- Education Education
- Blog Blog
- Support Desk Support Desk
01-09-2018 08:35 AM - edited 01-09-2018 08:39 AM
01-10-2018 07:04 AM - last edited on 01-10-2018 08:04 AM by kathleen_jo
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).
I would post this into the new Product Ideas forum.
This is a perfect candidate.
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.
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.
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..).
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
Copyright All Rights Reserved © 2008-2023