[resolved] Advanced Settings SQL Expression Syntax

[Anonymous]

Hi everyone,
Just a quick question: while typing in an SQL expression in the Advanced Settings/Additional Columns section of an SQL Output component, if I want to use the column I am referencing in the expression itself, how will I do it?
For example:
"CASE WHEN COL_1 LIKE '%ABC%' THEN SUBSTRING(COL_1, 12, 13) ELSE ' ' "
If I just type COL_1, Talend doesn't recognize the column. If I use 'COL_1', then Talend thinks it is just a bit of text.
Any ideas?
Thanks!
Cihan

[Anonymous]

Putting COL_1 in brackets also didn't work; Talend again couldn't recognize the column name.
Would be really glad if anyone had a solution/suggestion.
Thanks!

[Anonymous]

I tried using brackets around the column name, like . That also didn't work.

[_AnonymousUser · Accepted solution]

hi! try to use double quotes and concatenate the strings like this:
"CASE WHEN "+COL_1+" LIKE '%ABC%' THEN SUBSTRING("+COL_1+", 12, 13) ELSE ' ' "

[Anonymous]

OK, that should work. Thanks!