topic tMap - replacing a null for a value in Talend Studio

tMap - replacing a null for a value

RMotta2408 — Fri, 15 Nov 2024 21:32:17 GMT

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

Re: tMap - replacing a null for a value

anselmopeixoto — Wed, 26 Jul 2023 12:44:11 GMT

Hello @Rui Motta

Try using the following expression on the output column:

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

Re: tMap - replacing a null for a value

RMotta2408 — Wed, 26 Jul 2023 13:44:16 GMT

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

Re: tMap - replacing a null for a value

anselmopeixoto — Wed, 26 Jul 2023 17:53:43 GMT

I'm glad it worked.

Abraços,

Anselmo