PowerQuery syntax to append a string parameter

[Jaymond Flurrie]

A simple named "ShipmentSource" Excel cell has a value.

I try to put it into a variable:
let shipmentsource = Excel.CurrentWorkbook(){[Name="ShipmentSource"]}[Content]{0},

I try to replace this kind of SQL lines

/* RFQ Round */
DECLARE        @MyIntParameterValue int = 1

/* Shipment source */
DECLARE        @ShipmentSource nvarchar(50) = 'ThisIsMyShipmentSource'

with the content of ShipmentSource named cell:

/* Shipment source */#(lf)DECLARE#(tab)#(tab)
@ShipmentSource nvarchar(50) = '" & shipmentsource & "'#(lf)#(lf)

Result:

Expression.Error: We cannot apply operator & to types Text and Record.
Details:
    Operator=&
    Left=/* MyIntParameterValue */
DECLARE        @MyIntParameter int = 1

/* Shipment source */
DECLARE        @ShipmentSource nvarchar(50) = '
    Right=
        Column1=ThisIsMyShipmentSource

I could imagine this is very simple. And no, never before written a single line of PowerQuery code.

 

[pjmorris]

This is not an answer, but It is easy. I can never remember the syntax and have just Googled this search 'powerquery to retrieve the value of a cell on a spreadsheet' and a number of options appeared.

HTH

 

[Jaymond Flurrie]

This is not an answer, but It is easy. I can never remember the syntax and have just Googled this search 'powerquery to retrieve the value of a cell on a spreadsheet' and a number of options appeared.

HTH

Otherwise I have this done, but the parsing into the SQL query doesn't seem to work. I can make a table and I can make a text field out of the value, but that's where I hit the wall.

 

[Jaymond Flurrie]

I decided to do something a lot simpler to start with and managed to do it:

let
    myCountry = Excel.CurrentWorkbook(){[Name="Ctry"]}[Content]{0}[Column1],
    Source = Sql.Database("thedatabaseinstance", "mydatabasename", [Query="select top 10 *#(lf)from country Where Name Like '" & Text.From(myCountry)  & "'"])
in
    Source

The important parts are that this myCountry comes from a single named cell. Not a table, just a named cell.
That "Text.From"-function was the key here to get it to work.