You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] Tmap inner join with null
Post a reply
Topic review (newest first)
- 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
- janhess
- 2010-09-13 14:03:02
Are they null or empty fields?
- 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.
- 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