tmap null pointer exception

[BNP]

Hi All,

I'm new to Talend tool.

I' getting an error message in tmap component. I have given expression row1.DEPARTMENT_ID==100 && row1.SALARY >=16000, input file is Excel. Departmen_ID and Salary have data in both columns only one row does not have any data in Department_ID. I'm getting an error message like null exception. I have attached the screenshots. Kindly help me this out thanks in advance

Regards,

Bhaskar.

[Anonymous · Accepted solution]

Change your filter expression to
row1.DEPARTMENT_ID!=null&&row1.DEPARTMENT_ID==100 && row1.SALARY >=16000
Will solve the NPE issue.

[BNP]

Hi Shong,

Thank for given solution. Now it working exactly.

Regards,

Bhaskar