Talend community forum / [resolved] Tmap inner join with null

marcs · 2010-09-10 10:35:03

I try to do a inner join between all fields from table to another but it doesn't work if any source fields are null !!

Did you have the solution to manage null value ?

Regards
Marc

mrsocks · 2010-09-10 19:05:16

this sounds similar to what i am running into:

http://www.talendforge.org/forum/viewtopic.php?id=12278

if you find out the issue, please post back.

Thanks.

janhess · 2010-09-13 14:03:02

Are they null or empty fields?

marcs · 2010-09-13 15:52:56

Its ok with the usage of the COALESCE function to replace null value by a user defined string like "+NULL+".
I would like to also notice that be careful with the string type from sqlite because a "empty string" is not null !!

Regards
Marc

Announcement

Unanswered posts

#1 2010-09-10 10:35:03

[resolved] Tmap inner join with null

#2 2010-09-10 19:05:16

Re: [resolved] Tmap inner join with null

#3 2010-09-13 14:03:02

Re: [resolved] Tmap inner join with null

#4 2010-09-13 15:52:56

Re: [resolved] Tmap inner join with null

Board footer