[resolved] tmap filter empty string with tFileExcelInput

One Star

[resolved] tmap filter empty string with tFileExcelInput

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

Moderator

Re: [resolved] tmap filter empty string with tFileExcelInput

Hi,
Have you already checked option"Trim column" under advanced settings of tfileinputexcel?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] tmap filter empty string with tFileExcelInput

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

Re: [resolved] tmap filter empty string with tFileExcelInput

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
One Star

Re: [resolved] tmap filter empty string with tFileExcelInput

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