good morning I am searching if it possible to use variables, in the advanced query editor, something like this: instead of:------------ letOrigine = Sql.Database("99.99.99.99", "Mydb", [Query="select data from mytab where code = 66.... inOrigine something like this:--------------------- let variab = 66; letOrigine = Sql.Database("99.99.99.99", "Mydb", [Query="select data from mytab where code = variab ..... inOrigine or any doc about ... thanks

Yes, just add the named variable in a previous step, for example: let myVar = "66", Source = "myUrl" & myVarin Source This returns "myUrl66"

Forum Discussion

Helper V

9 years ago

Solved

good morning

I am searching if it possible to use variables, in the advanced query editor, something like this:

instead of:

------------

let
Origine = Sql.Database("99.99.99.99", "Mydb", [Query="select data from mytab where code = 66....

Origine

something like this:

---------------------

let variab = 66;

let
Origine = Sql.Database("99.99.99.99", "Mydb", [Query="select data from mytab where code = variab .....

Origine

or any doc about ...

thanks