expression

Question

Hello,
What is wrong with this expression please?
I think it requires single quote around surename?
Note that I do not get an expression error but when I run this in pipeline copy sink I get an error.
When I narrow it down it looks like it is to do with single quotes that need to be around surname value but I can not get it to work.
Thank you

@markus.bohland@hotmail.de ('http://webaddress filter xyz in (', dataset().p_surename, ')')

Answer 1

Hi @arkiboys ,

if you want to put single quotes around surname, you can try ''' instead of ' e.g.,
@markus.bohland@hotmail.de ('http://webaddress filter xyz in (''', dataset().p_surename, ''')')

Thanks!