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)
Best answer by JTreadwell
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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
