How to use variable column name in SQL query?

[rajankur6494]

[ FlexSim 23.1.1 ]

Hi Team,

I am trying to pass the variable column name in SQL query, but it is not working as expected. This is first time when I am using variable column name instead of column values. Here, I am assigning Week as variable value to column and using SUM formula over it.

Is this syntax correct?

Could you help me to resolve it?

Thank you!

[joerg_vogel_HsH · Accepted solution]

I do not know, but

string Week = "Wk_1";
string qstr = "SELECT SUM("+Week+") FROM GlobalTable1";
Table result = Table.query(qstr);

this works.

[rajankur6494]

Thanks! @Joerg Vogel

It is working.