How to make columns names parametric in Execute Query Activity

Help
, ,
1

Hi all,

i want to make columns names parametric when i execute queries from sql server in uipath but i can not do it. It should work for every current month.

image
image887×512 23.1 KB

I try to do it like that but it doesn’t work. The currentmonth variable is true.

Is there anyone who know how to do that?

2

@mazlumkacar,

Try coming passing the in_CurrentMonth enclosed by a double quotes and + sign.

ex:
As per your query you need to change all current month variable as following
,[2019 “+in_CurrentMonth+” B]

My Sample Query:
"Select * From mytable where col1 = "+in_Values

3

@sarathi125

i did it but now i am getting this error.

image
image973×556 29.8 KB

4

@mazlumkacar,

At end of the query you have an extra double quote, remove and try.