I have a query which merge a with another query..
the table which i want to merge is taken from input variable, so the query as given below
currently Cri value is POSDATA
error is getting when i change the POSDATA to Cri (6th line). How i can put table name in input variable
let
Cri = Type as text,
Source = Excel.CurrentWorkbook(){[Name="RECIPE"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Bill Item Code", Int64.Type}, {"POS PLU Code", Int64.Type}, {"Bill Item Description", type text}, {"Component", Int64.Type}, {"Description", type text}, {"UOM", type text}, {"Quantity Per Assembly", type number}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type",{"POS PLU Code"},POSDATA,{"PLUCODE"},Cri,JoinKind.LeftOuter),
#"Expanded POSDATA" = Table.ExpandTableColumn(#"Merged Queries", Cri, {"Qty"}, {"Qty"}),
#"Inserted Multiplication" = Table.AddColumn(#"Expanded POSDATA", "Total Qty", each [Quantity Per Assembly] * [Qty], type number),
#"Grouped Rows" = Table.Group(#"Inserted Multiplication", {"Component", "Description", "UOM"}, {{"Total Quantity Sold", each List.Sum([Total Qty]), type number}}),
#"Filtered Rows" = Table.SelectRows(#"Grouped Rows", each ([Total Quantity Sold] <> null))
in
#"Filtered Rows"
the table which i want to merge is taken from input variable, so the query as given below
currently Cri value is POSDATA
error is getting when i change the POSDATA to Cri (6th line). How i can put table name in input variable
let
Cri = Type as text,
Source = Excel.CurrentWorkbook(){[Name="RECIPE"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Bill Item Code", Int64.Type}, {"POS PLU Code", Int64.Type}, {"Bill Item Description", type text}, {"Component", Int64.Type}, {"Description", type text}, {"UOM", type text}, {"Quantity Per Assembly", type number}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type",{"POS PLU Code"},POSDATA,{"PLUCODE"},Cri,JoinKind.LeftOuter),
#"Expanded POSDATA" = Table.ExpandTableColumn(#"Merged Queries", Cri, {"Qty"}, {"Qty"}),
#"Inserted Multiplication" = Table.AddColumn(#"Expanded POSDATA", "Total Qty", each [Quantity Per Assembly] * [Qty], type number),
#"Grouped Rows" = Table.Group(#"Inserted Multiplication", {"Component", "Description", "UOM"}, {{"Total Quantity Sold", each List.Sum([Total Qty]), type number}}),
#"Filtered Rows" = Table.SelectRows(#"Grouped Rows", each ([Total Quantity Sold] <> null))
in
#"Filtered Rows"
Last edited: