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

[Anonymous]

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

[fdenis]

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,

[fdenis · Accepted solution]

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