topic Re: [resolved] tmap filter empty string with tFileExcelInput in Talend Studio

[resolved] tmap filter empty string with tFileExcelInput

Anonymous — Wed, 03 Sep 2014 10:53:13 GMT

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

Re: [resolved] tmap filter empty string with tFileExcelInput

Anonymous — Wed, 03 Sep 2014 11:19:04 GMT

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

Re: [resolved] tmap filter empty string with tFileExcelInput

Anonymous — Wed, 03 Sep 2014 11:34:51 GMT

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

Re: [resolved] tmap filter empty string with tFileExcelInput

Anonymous — Wed, 03 Sep 2014 14:04:56 GMT

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

Re: [resolved] tmap filter empty string with tFileExcelInput

Anonymous — Wed, 03 Sep 2014 16:06:33 GMT

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