How to make columns names parametric in Execute Query Activity

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.

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?


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

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


i did it but now i am getting this error.


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