Post reply

How to separate invalid data from table

  • August 21, 2008 at 2:36 am

    #130776

    Dear All

    I have a table having column1 varchar(8) cloumn2 varchar(8) which stores date and value rspt. But these two columns also contains invalid data as '20014545' as date and 'IN-DEV' as value . Can anybody help me out there so that I can have a separate table which will be having such invalid data in a separate file along with recordno OR line no.

    How can one deal with such situation.

  • August 21, 2008 at 3:14 am

    #861092

    For the date column, use a data convert component. Redirect failures into a union all.

    Put a conditional split after the conversion and do a check for invalid values in the second column. divert them to a new ouput. Send that output to the same union all.

    From the union all, push those into a table.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply