topic Re: [resolved] Advanced Settings SQL Expression Syntax in Talend Studio

[resolved] Advanced Settings SQL Expression Syntax

Anonymous — Tue, 17 Jun 2014 11:15:36 GMT

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

Re: [resolved] Advanced Settings SQL Expression Syntax

Anonymous — Tue, 17 Jun 2014 15:14:31 GMT

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!

Re: [resolved] Advanced Settings SQL Expression Syntax

Anonymous — Wed, 18 Jun 2014 08:01:18 GMT

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

Re: [resolved] Advanced Settings SQL Expression Syntax

_AnonymousUser — Wed, 18 Jun 2014 17:33:41 GMT

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 ' ' "

Re: [resolved] Advanced Settings SQL Expression Syntax

Anonymous — Fri, 20 Jun 2014 08:42:40 GMT

OK, that should work. Thanks!