Today when i was using tFilter option in Talend My filter was not fetching correct result. Check below the screenshot.
Then i decided to try Use Advance mode option and i wrote below code.
(input_row.SAP_ID.equals(null)) && (input_row.Name_1.equals(null)))
still it was not working as needed, might be because null is not meant for equals function.
I tried (input_row.SAP_ID!="" && (input_row.Name_1!="")) but no luck.
Then i searched and found Talend compare strings lexicographically so I tried to use below code and it worked perfectly.
(input_row.SAP_ID.compareTo("")!=0) && (input_row.Name_1.compareTo("")!=0)
So i got answer why above screenshot fetches wrong result which can be corrected as
