topic Re: String conditions in a tMap in Talend Studio

String conditions in a tMap

EvoticTalend — Fri, 15 Nov 2024 23:44:34 GMT

Hi everyone, I have this two columns. First for the phone, second for the email.

I WANT IN A TMAP:

If column PHONE and column EMAIL are NOT NULL = 3

If column PHONE IS NULL and column EMAIL IS NOT NULL = 1

If column PHONE IS NOT NULL and column EMAIL IS NULL = 2

If column PHONE IS NULL and column EMAIL IS NULL = 0

In this screenshot would be:

I know to do a condition in a tmap but i dont know to do more than one.

Re: String conditions in a tMap

Mahamoutou — Tue, 14 Sep 2021 09:10:12 GMT

Here is a way to go :

Re: String conditions in a tMap

EvoticTalend — Tue, 14 Sep 2021 10:21:33 GMT

Hi! Thank you for the response but I tried your code and didn't work... only see 3 in all columns.

Re: String conditions in a tMap

Mahamoutou — Tue, 14 Sep 2021 10:43:08 GMT

Please, could you post a capture of your attempt ?

Re: String conditions in a tMap

EvoticTalend — Tue, 14 Sep 2021 10:46:56 GMT

Re: String conditions in a tMap

Mahamoutou — Tue, 14 Sep 2021 11:19:29 GMT

Thanks for your quick reply.

This problem is probably an "empty string" vs "null value" problem. So I would suggest you to add conditions to handle empty string too. Please, see the screen.

Re: String conditions in a tMap

Anonymous — Wed, 15 Sep 2021 03:21:05 GMT

Hello,

That is really good answer, have you thought of entering our competition?

https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day

There are rewards for winners!

Best regards

Sabrina