topic Re: Concatenate null into result in Talend Studio

Concatenate null into result

Anonymous — Sat, 16 Nov 2024 05:51:55 GMT

Hello Team,

Here is my question.

i have three fields migrated to one output field - data type is string

In data i have null, 1 like that

If i migrate , it showing as nullnullnull

I want them as one NULL , In case if it come as 1nullnull - it should result as 1 , null2null it should result as 2

I wrote a Tmap expression :

row1.col1==null&& row1.col2==null&& row1.col3==null? "NULL":row1.col1+row1.col2+row1.col3

but it result 1nullnull, i need them as 1 - if it gets data in three = it should result the sum as well !!!

(Or)

Tell me how can i convert NULL into 0 and do this concatenation ?

Help out !!

Thanks for your help in advance !!!!

Re: Concatenate null into result

bhagyarekha — Mon, 13 May 2019 06:26:38 GMT

here your data type is string,so you are getting result as like that,strings will append,integer will get add give you the sum

you need to convert it into int again by using tconverttype,

Regards,

Rekha

Re: Concatenate null into result

bhagyarekha — Mon, 13 May 2019 07:15:51 GMT

@prabuj27

i have three fields migrated to one output field - data type is string

how you are doing this on what condition are you doing?

can you let us know full flow of your requirement and at last what datatype should be used

first your requirement was this right?

Value is 1, if it have value , Value is NULL, it have no value - tmap expression helppppp !!!!

if present requirement was continuation for old question we need to do some changes

Regards

rekha

Re: Concatenate null into result

Anonymous — Mon, 13 May 2019 08:01:48 GMT

@bhagyarekha

x (string) y(string) z (string) output ( string)

null null null nullnullnull

null 1 null 1

1 4 6 11

Result required: nullnullnull null

null1null 1

146 11

This is what i need. can you give me a query ????

(or)

Convert the null as 0 - i.e string to integer in the expression syntax - and get the result. am okay in both ways .. but need the result

Thanks in advance !!!!!!!

Re: Concatenate null into result

Anonymous — Mon, 13 May 2019 08:24:36 GMT

@bhagyarekha

x(str) y(str) z (str) output ( str) required output

null null null nullnullnull null

1 null null 1nullnull 1

1 4 6 11 11

Can you tell me a expression syntax to achieve this result ???

Re: Concatenate null into result

bhagyarekha — Mon, 13 May 2019 10:22:17 GMT

@prabuj27

pfa might be useful

regards

rekha

test3_0.1.zip