Skip to main content

I have the following set of tables:


A (key1, key2)


B (key2, key3)


In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B.


When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values?


I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views?


So the goal table should be like


C (key1, key2, key3)

Hi hgr, 

Thank you for your post. The key here, in Discovery Hub, is that you want drag lookups from the "one" to the "many" of a one to many relation ship. So your issue here is the granularity. In Discovery Hub, by design, Conditional Lookups will never modify the granularity of a table. So you cant take all values of key3 and make them fit into table A because there is not enough records. 

So to solve your problem you would drag key1 from table A into table B. This table would then become your Table C. 

For more information you can read more about relations and conditional lookups in our online training. Hope that helps!


Reply