Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Here is a way to go :
Hi! Thank you for the response but I tried your code and didn't work... only see 3 in all columns.
Please, could you post a capture of your attempt ?
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.
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