String conditions in a tMap

[EvoticTalend]

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:

3

1

2

0

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

[Mahamoutou]

Here is a way to go :

[EvoticTalend]

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

[Mahamoutou]

Please, could you post a capture of your attempt ?

[EvoticTalend]

 

 

[Mahamoutou]

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.

[Anonymous]

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