Forum Discussion
Alternative to Nested Lookups to Bridge Unrelated Datasets
Hi,
I'm trying to find an alternative to nested lookup tables (which aren't allowed in Report Builder) that allow me to do the following:
I want to bring data from Dataset 3 into a table that initially had data from Dataset 1 in. I can create a lookup with Dataset 1 and 2, or I can create one with 2 and 3. However I cannot use a nested lookup for 1 and 3 and don't know what else is possible.
What function can I use to bridge Dataset 1 and 3?
Dataset 1
| Col1 | Col2 |
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
| 5 | e |
| 6 | f |
Dataset 2
| Col2 | Col3 |
| a | 7 |
| b | 8 |
| c | 9 |
| d | 10 |
| e | 11 |
| f | 12 |
Dataset 3
| Col3 | Col4 |
| 7 | g |
| 8 | h |
| 9 | i |
| 10 | j |
| 11 | k |
| 12 | l |
Much appreciated,
Will
2 Replies
- lbendlin
Super User
Would this work ?
Table.Join(Table.Join(#"Dataset 1","Col2",#"Dataset 2","Col2"),"Col3",#"Dataset 3","Col3")
