Forum Discussion
amien
Helper V
Helper Vconsuming a variable in a copy data job?
In a pipeline i run a notebook. In the end of this notebook i do a mssparkutils.notebook.exit After the notebook is done, i have added a 'Set variable' with this setting : @activity('Notebook').o...
I think the syntax should be something like...
@concat( 'select week, value from TableName where week = ' , variables('Maxweek_') )depending on how you've written your variable, you may need to enclose it in quotes, and the escaping of quotes can be confusing...
@concat( 'select week, value from TableName where week = ' , '''' , variables('Maxweek_') , '''' )So that '''' is surrounding the concat item in '' and then another '' one to escape the other.
Yeah, you need to use the add dynamic content option for this.
KNP
Super User
Super UserI think the syntax should be something like...
@concat(
'select week, value from TableName where week = '
, variables('Maxweek_')
)
depending on how you've written your variable, you may need to enclose it in quotes, and the escaping of quotes can be confusing...
@concat(
'select week, value from TableName where week = '
, ''''
, variables('Maxweek_')
, ''''
)
So that '''' is surrounding the concat item in '' and then another '' one to escape the other.
amienit does work (first option) .. only thing is that it will remove the 'edit' button 🙂