To homepage To homepage
Solved

Conditional Lookup multiple values

  • 8 March 2019
  • 1 reply
  • 64 views
H
Rank
  • hgr
  • Contributor
  • 8 replies

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)

icon

Best answer by JTreadwell 5 September 2019, 01:39

View original

1 reply

JTreadwell
Rank
Userlevel 3
Badge +5

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!

-Joseph Treadwell

Reply


Terms and ConditionsCookie settings