topic Re: CONCATENATE COLUMN(string) in tMap BUG if is NULL? in Talend Studio

CONCATENATE COLUMN(string) in tMap BUG if is NULL?

Anonymous — Thu, 08 Aug 2013 21:30:07 GMT

Hi,
I have tOracleInput_>tMap->tAggregateRow->tOralceOutput
In tMap I make (row1.column1)+(row1.column2)+(row1.column3) in tMap out field.

If column1 or column2 or column3 are NULL in output i have for example:
AnullC
nullnullC
ABnull
Anullnull
nullnullnull
I'm going to have:
AC
C
A
AB
""
Where I'm wrong????

Thanks in advance,
Gino.

Re: CONCATENATE COLUMN(string) in tMap BUG if is NULL?

Anonymous — Fri, 09 Aug 2013 03:05:43 GMT

Hi,
If I understand you very well, you can use

(row1.Column1 + row1.Column2 + row1.Column3).replaceAll("null","")

in tMap expression. At first, set your data schema as "string".

Best regards
Sabrina

Re: CONCATENATE COLUMN(string) in tMap BUG if is NULL?

_AnonymousUser — Fri, 21 Oct 2016 05:29:23 GMT

replaceAll("null","") won't work as expected if the strings by chance contain the substring "null"