topic Re: tmap String Expression concatenate multiple input columns into one output column by checking for blanks and NULLS and one distinct value "UNKNOWN" in Talend Studio

tmap String Expression concatenate multiple input columns into one output column by checking for blanks and NULLS and one distinct value "UNKNOWN"

Anonymous — Mon, 11 Mar 2019 22:13:25 GMT

Need to concatenate multiple input columns into one output column by checking for blanks and NULLS and one distinct value "UNKNOWN"

Multiple input columns of mine contain codes that I need to concatenate together no spaces inbetween values. Also to change blank values to those concatenated strings and values in that mpf1 column that have "UNKNOWN"

Do I have the concatenation right?

Will "Unknown" and blank strings going to be outputted with the 6 concatenated strings with this syntax below?

"Unknown".equalsIgnoreCase(row1.mpf1) || "".equalsIgnoreCase(row1.mpf1)? row1.mpf1 + '' + row1.mpf2 + '' + row1.mpf3 + '' + row1.mpf5 + '' + row1.mpf6 : row1.mpf1 + '' + row1.mpf2 + '' + row1.mpf3 + '' + row1.mpf5 + '' + row1.mpf6

Thanks

Andrew

Re: tmap String Expression concatenate multiple input columns into one output column by checking for blanks and NULLS and one distinct value "UNKNOWN"

fdenis — Tue, 12 Mar 2019 08:55:31 GMT

hi,
((row1.mpf1!=null && row1.mpf1.equalsIgnoreCase("Unknown"))?"":row1.mpf1) + row1.mpf2 + row1.mpf3 + row1.mpf5 + row1.mpf6
is better.
in java "" string is null.

Regards,

Re: tmap String Expression concatenate multiple input columns into one output column by checking for blanks and NULLS and one distinct value "UNKNOWN"

fdenis — Tue, 12 Mar 2019 08:56:21 GMT

((String)((row1.mpf1!=null && row1.mpf1.equalsIgnoreCase("Unknown"))?"":row1.mpf1) + row1.mpf2 + row1.mpf3 + row1.mpf5 + row1.mpf6)
assume that it's a String