https://community.qlik.com/t5/Talend-Studio/Null-and-Not-Null-validation-in-Tmap/m-p/2250239#M34544 Hi,<BR /> I am sending a main file into tmap. Then I have a lookup table from db to validate the brand_code from file. The column in the file can be null or not null. If not null then it has to be validated. If null then too it must be treated as valid value. So the output can have nulls. <BR /> I am using inner join in tmap. So that I can validate when there is a value in brand_code column. But if the column value is null then too its validating and rejecting that record. <BR /> Can anyone suggest a solution for the above issue.<BR />Thanks,<BR />Soumya Wed, 15 Aug 2012 17:05:58 GMT Anonymous 2012-08-15T17:05:58Z https://community.qlik.com/t5/Talend-Studio/Null-and-Not-Null-validation-in-Tmap/m-p/2250239#M34544 Hi,<BR /> I am sending a main file into tmap. Then I have a lookup table from db to validate the brand_code from file. The column in the file can be null or not null. If not null then it has to be validated. If null then too it must be treated as valid value. So the output can have nulls. <BR /> I am using inner join in tmap. So that I can validate when there is a value in brand_code column. But if the column value is null then too its validating and rejecting that record. <BR /> Can anyone suggest a solution for the above issue.<BR />Thanks,<BR />Soumya Wed, 15 Aug 2012 17:05:58 GMT https://community.qlik.com/t5/Talend-Studio/Null-and-Not-Null-validation-in-Tmap/m-p/2250239#M34544 Anonymous 2012-08-15T17:05:58Z https://community.qlik.com/t5/Talend-Studio/Null-and-Not-Null-validation-in-Tmap/m-p/2250240#M34545 Change the tMap to left join and use an output expression filter like: <BR />filerow.brand_code==null || lookuprow.brand_code!=null Thu, 16 Aug 2012 02:48:26 GMT https://community.qlik.com/t5/Talend-Studio/Null-and-Not-Null-validation-in-Tmap/m-p/2250240#M34545 alevy 2012-08-16T02:48:26Z