[resolved] tmap filter empty string with tFileExcelInput

[Anonymous]

Hi,
In my job design, I have tFileExcelInput as main tMap. In tMap component, I have put condition to filter on one field (data type as string) to check is it null. I tested with !=null, but it doesn't work cuz in tLogRow, I still could see row with this field as empty string output.
Could anybody tell me how to solve this?
Sophanna

[Anonymous]

Hi,
Have you already checked option"Trim column" under advanced settings of tfileinputexcel?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I already check it. But in tLogRow output still output row with this empty field.
Sophanna

[Anonymous]

hi all,
check for null & empty value "" perhaps.
if you anly filter some value, you can do it with a tFilterRow instead of tMap
regards
laurent

[Anonymous]

Hi Kzone,
Thanks for your reply. Actually I just review my excel datasource that I export from access database and there is default value as "", that's why the field is not blank.
Best regards,
Sophanna