topic Re: [resolved] tFilter Row empty date values in Talend Studio

[resolved] tFilter Row empty date values

Anonymous — Sat, 16 Nov 2024 12:25:46 GMT

Hi all,
I'm trying to read datasets from an excel sheet that contains datasets with an empty date value and put into a MS SQL database table.
The receiving database doesn't allow blank or null values so I'm trying to filter them using the tFilterRow component. Surely I can manually add fake date values to satisfy the MS SQL database, however I would like to run the job automaticall and it's impossible to modify the Excel input sheet itself (created by a 3rd party database tool).
I'd be grateful if somebody has an easy solution.
Cheers,
Nils

Re: [resolved] tFilter Row empty date values

Anonymous — Wed, 25 Jan 2012 14:23:24 GMT

N1866,
Add a tMap component between your tInputExcel and your tMssqlOutput.
In the tMap just do a 1:1 mapping and add an expression in the output box by saying "row1.YourDateFieldName is not null".
Regards

Re: [resolved] tFilter Row empty date values

Anonymous — Wed, 25 Jan 2012 14:27:21 GMT

N1866,
Ah no sorry I was wrong, it needs to be : "row1.YourDateFieldName != null"
Was mixing the expression up with SQL and SSIS. 🙂
Regards

Re: [resolved] tFilter Row empty date values

Anonymous — Thu, 28 Mar 2013 06:27:30 GMT

"row2.eff_date != null" returns the following error: Type mismatch: cannot convert from boolean to Date
Never in my process row2.eff_date is defined as a boolean.

Re: [resolved] tFilter Row empty date values

Anonymous — Thu, 28 Mar 2013 07:26:20 GMT

Hi magdmartin
From your error code information, did you set the condition

"row2.eff_date != null"

in tMap Expression? It should be set in filter expression.
Please refer to component reference tMap
In addition, could you give us more job information? It will be helpful for us giving a hand to you.
Best regards
Sabrina

Re: [resolved] tFilter Row empty date values

Anonymous — Fri, 10 May 2013 00:53:56 GMT

Thanks xdshi for the answer (and sorry for the long silence). It did works and I am using this expression on a regular basis now.

Re: [resolved] tFilter Row empty date values

Anonymous — Fri, 10 May 2013 04:47:13 GMT

Hi magdmartin,
It is a good news for us, thanks for your feedback.
Best regards
Sabrina