How to use variable column name in SQL query?

Question

question

Ankur A3 asked Jun 19, '24 Ankur A3 commented Jun 21, '24

How to use variable column name in SQL query?

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!

Software Version:

FlexSim 23.1.1

sql query variable column sum

1718808317133.png (98.0 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2024-06-19T16:47:52Z

Joerg Vogel answered Jun 19, '24 Ankur A3 commented Jun 21, '24

I do not know, but

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

this works.

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ankur A3 commented · Jun 21 at 07:23 AM

Thanks! @Joerg Vogel

It is working.

0 ·

question