tMap - replacing a null for a value

[RMotta2408]

Hi everyone,

I'm trying to replace a NULL value for a different value on tMap, using the expression builder.

Something like this:

If row1.number is null then the number column on the output should be 1. Otherwise, the output number should be the same as the row1.number value.

Can anyone please help me?

Thanks in advance

Rui

[anselmopeixoto · Accepted solution]

Hello @Rui Motta​ 

Try using the following expression on the output column:

row1.number == null? 1 : row1.number

[RMotta2408]

Hi @Anselmo Peixoto​ 

Yessir! That's it!

Thank you so much. I appreciate it.

Judging from you name, I better say muito obrigado. Serviu na perfeição. Abraço

[anselmopeixoto]

I'm glad it worked.

Abraços,

Anselmo