How to write bad dates (contains alpha) to a reject table

ds2010 · Post by **ds2010** » Tue Aug 31, 2010 9:15 am

Hi Everyone,

I am new to DS and is in need of help on how to write a record with incorrect dates (contain alpha) in DS to a reject table without having a lookup table to reference.

From what I have read one way to write to a reject table is by having lookup file set pointing to a source with lookup values. However, in this case we are dealing with dates and we do not have a time dimension or any source that we can use for lookup. I hope I am explaining it right. Thanks in advance for your help!

chulett · Post by **chulett** » Tue Aug 31, 2010 9:27 am

Check out the use of the IsValid() function, it can be used for various data types including dates.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 31, 2010 10:23 am

You would use the IsValid() function in a Transformer stage that has two outputs, one for times when the record is in some way invalid. This would server as your link to your rejects table.