https://community.qlik.com/t5/Talend-Studio/tMap-Inner-Join-NULL-Rejected-Really-need-help/m-p/2243980#M30277 Hello <BR />I have a main table that has a few columns: <BR />MAIN_SHIPMENT <BR />id | date | brand_id | item_number <BR />and record in this are currently 1:1 but in the new system will allow 1:X <BR />so the new table structures are going to be: <BR />SHIPMENT <BR />id | date <BR />ITEMS <BR />id | shipment_id | brand_id | item_number <BR />There is also a table Brands that has a relationship to the 'brand_id' field. This field in 'ITEMS' can be null. <BR />Any records in the MAIN_SHIPMENT table that have a brand_id of 4 or 5, i want to change to null, so I am using a tJavaRow action before the tMap. <BR />So technically, the tMap should be receiving null for the brand_id and that should be allowable and so inserted into the ITEMS table...but it's not. It's being bounced into the 'outputRejects' / errors table. <BR />I have attached some images and tried to simplify the explanation, but the images show, of what i can, the actual job. If anyone can provide any suggestions as to what is going on that would be great. <BR />So even though my ITEMS table allows null brand_id values, they are being rejected. <BR />To setup the outputReject, i followed the tutorial on <A href="http://www.talendforge.org/tutorials/tutorial.php?language=english&amp;idTuto=9" target="_blank" rel="nofollow noopener noreferrer">http://www.talendforge.org/tutorials/tutorial.php?language=english&amp;idTuto=9</A> <BR />Thanks. Sat, 16 Nov 2024 13:17:30 GMT Anonymous 2024-11-16T13:17:30Z https://community.qlik.com/t5/Talend-Studio/tMap-Inner-Join-NULL-Rejected-Really-need-help/m-p/2243980#M30277 Hello <BR />I have a main table that has a few columns: <BR />MAIN_SHIPMENT <BR />id | date | brand_id | item_number <BR />and record in this are currently 1:1 but in the new system will allow 1:X <BR />so the new table structures are going to be: <BR />SHIPMENT <BR />id | date <BR />ITEMS <BR />id | shipment_id | brand_id | item_number <BR />There is also a table Brands that has a relationship to the 'brand_id' field. This field in 'ITEMS' can be null. <BR />Any records in the MAIN_SHIPMENT table that have a brand_id of 4 or 5, i want to change to null, so I am using a tJavaRow action before the tMap. <BR />So technically, the tMap should be receiving null for the brand_id and that should be allowable and so inserted into the ITEMS table...but it's not. It's being bounced into the 'outputRejects' / errors table. <BR />I have attached some images and tried to simplify the explanation, but the images show, of what i can, the actual job. If anyone can provide any suggestions as to what is going on that would be great. <BR />So even though my ITEMS table allows null brand_id values, they are being rejected. <BR />To setup the outputReject, i followed the tutorial on <A href="http://www.talendforge.org/tutorials/tutorial.php?language=english&amp;idTuto=9" target="_blank" rel="nofollow noopener noreferrer">http://www.talendforge.org/tutorials/tutorial.php?language=english&amp;idTuto=9</A> <BR />Thanks. Sat, 16 Nov 2024 13:17:30 GMT https://community.qlik.com/t5/Talend-Studio/tMap-Inner-Join-NULL-Rejected-Really-need-help/m-p/2243980#M30277 Anonymous 2024-11-16T13:17:30Z https://community.qlik.com/t5/Talend-Studio/tMap-Inner-Join-NULL-Rejected-Really-need-help/m-p/2243981#M30278 NULL generally does not join to NULL. <BR /> you can use COALESCE() in your source query to convert the nulls to a crazy value that wont collide with your id's (-1 or something) that you can then use in your tmap to join with. Sat, 11 Sep 2010 03:16:38 GMT https://community.qlik.com/t5/Talend-Studio/tMap-Inner-Join-NULL-Rejected-Really-need-help/m-p/2243981#M30278 Anonymous 2010-09-11T03:16:38Z