Replace from value of other column

[Anonymous]

I'm starting using the Talend big data.

I wanna replace the nulls of one column by the value of the other?

It's this possible?

Regards,

Vitor Sousa

[manodwhb · Accepted solution]

you can do in tMap by writing below way.

row1.lname==null? row1.fname : row1.lname

[Anonymous]

Thanks!

[TRF]

Hi,

Suppose the flow before your tReplace is called row74 (like in the following capture), you can refer to the desired column your want to get to replace "NULL" or null values in the source column.

Here, the target column is called newColumn1 and the source is newColumn.

This make the job:

In my example the input data are the following:

And the result is:

Hope this helps.

[Anonymous]

I will try. But thanks for the help.