how to concatenate 2 columns of string data type - 1 and 3 to result 4 in output

[Anonymous]

x(str)     y(str)        z(str)                     Output (str)           RequiredOutput

null         1              null                       null1null                         1

1             2               3                            123                             6

Query used: 

row1.x==null && row1.y==null && row1.z==null ? 0:row1.x+row1.y+row1.z

Someone help to get the required output ??

Thanks in Advance.

Prabuj

[TRF]

As soon as input fields are strings, the + operator is for concatenation, not for addition.

If the expression is used in a tMap component, you should use local variables to simplify it (1 local for each input field to convert from string to int and deal with null values).

[Anonymous]

@TRF exactly as you said, can you show some example how it can be done or any link to refer

[TRF · Accepted solution]

Start with this:

[Anonymous]

@TRF awesome, made my day !!!