Forum Discussion
amien
Post Patron
Post Patronconsuming 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.
Hi amien ,
Did KNP reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best regards,
Adamk Kong