Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Two Share Point List no relationship joins

I have two tables from a share point list, both the tables have their primary ID's. I would like to take each ID from one table and show all the possibilities of the other table in one query. Is this...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    If you want to create a new query, please create a new blank query, use code in Advanced editor as below:

    let
    Source = Table.SelectColumns(#"Table 1",{"ID1"}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each #"Table 2"[ID2]),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom")
in
    #"Expanded Custom"

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

If you want to create a new query, please create a new blank query, use code in Advanced editor as below:

let
    Source = Table.SelectColumns(#"Table 1",{"ID1"}),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each #"Table 2"[ID2]),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom")
in
    #"Expanded Custom"

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.