Conditional Lookup multiple values

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)

1 comment

Please sign in to leave a comment.