Hi all guys, I have a problem filtering input data (Date type) from a tFileInputPositional; I am not able to filter input data, excluding dates like "00000000" ("yyyyMMdd" format).

Here my situations:

-------------------------------------------
INPUT DATA SCHEMA: see "input_data_sample.png"

I have some simple data with some date fields: dates with non value are wrote has "00000000".

I DON'T WANT those data in the output and I'd like to exclude them at the beginning, when I load input data.

-------------------------------------------
JOB SCHEMA: ref. image "Job_Schema.png"

As you can see in image 2, even if I put an exeption in the tMap (see image "tMap_exeption.png"), the record with 'null' date goes in the output.
In this case, to configure tFileInputPositional, I use the custom settings to define the schema, I tried also to define only the simple positional schema like "5,12,12,12,8,7,....", but in this case, date = "00000000" goes into the output as "30-11-0002" (and this is strange)!!!

Anyway it is not a big problem, becouse wrong data should be not into the output: "ALAN AFANETTI" should not be in the third tLogRow output.


Thanks to all for help, if you need more info, please ask to me!

Last edited by ienax_ridens (2012-04-11 16:56:49)