Query parameters equal to cell reference

[DomanicD]

Hello,
I am working on a file import where the reference workbook contains sheets labeled by day, 1st through 31st, for the month. I want the query to pull, according to a reference cell, the appropriate day of month sheet.

How can I edit the parameters to adjust for a date change and pull the appropriate sheet?


Source = Excel.Workbook(File.Contents("S:\National Desk\Reports\Flash\Nice\Third Party FTE requests\OctoberGate.xlsm"), null, true),
#"16th_Sheet" = Source{[Item="16th",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"16th_Sheet", [PromoteAllScalars=true]),

 

[DomanicD]

Hello,
I am working on a file import where the reference workbook contains sheets labeled by day, 1st through 31st, for the month. I want the query to pull, according to a reference cell, the appropriate day of month sheet.

How can I edit the parameters to adjust for a date change and pull the appropriate sheet?


Source = Excel.Workbook(File.Contents("S:\National Desk\Reports\Flash\Nice\Third Party FTE requests\OctoberGate.xlsm"), null, true),
#"16th_Sheet" = Source{[Item="16th",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"16th_Sheet", [PromoteAllScalars=true]),

Was able to figure this out by building to parameter tables that took.

Source = Excel.Workbook(File.Contents("S:\National Desk\Reports\Flash\Nice\Third Party FTE requests\OctoberGate.xlsm"), null, true),
#"SheetName" = Source{[Item= Day,Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"SheetName", [PromoteAllScalars=true]),

 

[sandy666]

Great that you solved it but one more thing, use [CODE=pq] your code here [/CODE] in proper forum