Merge Table with Input Variable

sadath

Board Regular
Joined
Oct 10, 2004
Messages
245
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"
 
Last edited:

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,017
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top