Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've this query with an sql statement:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=2016")
I would like to insert the year (2016) through a parameter.
I've created the parameter "year(2016)" but I don't know how to define it in the sql statement.
Thanks in advance
Solved! Go to Solution.
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
hi almagir,
try the following:
= Odbc.Query("dsn=churrera", "sel top 10* from dwpryvp0.jnfs_territBO_vent_v_new where fx_anno=" & year)
regards,
konrad
Hi Konrad,
It has worked as you told me.
I've had to convert the number 2016 to text.
Thanks for your help.
Regards
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |