Forum Discussion

Leeroy444's avatar
Leeroy444
New Member
3 years ago
Solved

Loop through Inner Join Merge to Filter Table

Hi Everyone,  I have a data_table and a filter_table.  I would like to use the filter_table to filter the data_table.  This allows users to define a complex set of filters in a concise way. The he...
Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    Leeroy444 

     

    let
    Source = Table.NestedJoin(Filter_Table, {"Product"}, Table.SelectRows(Data_Table, each [ID] < 2), {"Product"}, "Data_Table", JoinKind.Inner),
    #"Expanded Data_Table" = Table.ExpandTableColumn(Source, "Data_Table", {"Category", "Category 1", "Category 2"}, {"Data_Table.Category", "Data_Table.Category 1", "Data_Table.Category 2"})
    in
    #"Expanded Data_Table"

     

     

     

    Leeroy444 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Leeroy444 

 

let
Source = Table.NestedJoin(Filter_Table, {"Product"}, Table.SelectRows(Data_Table, each [ID] < 2), {"Product"}, "Data_Table", JoinKind.Inner),
#"Expanded Data_Table" = Table.ExpandTableColumn(Source, "Data_Table", {"Category", "Category 1", "Category 2"}, {"Data_Table.Category", "Data_Table.Category 1", "Data_Table.Category 2"})
in
#"Expanded Data_Table"

 

 

 

Leeroy444 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.