DSXchange

Hi All,

I have a seq file stage in a job that at times has 1 less columns than i am expecting so I have changed the job to discard and warn on any incomplete columns. But what I want to do is put the discard out to an exception file so I can monitor these discards.

Is there anyway of doing this?

Regards
Brad

Use replace option and use replacement value of something like "XXXXYYYYYZZZ" or something very noticeable and unlikely to appear in the missing column. Then, put a constraint on the following transformer to place the rows that have that column value in your reject file.

how/where do i tell it the value that i want to replace the missing column with?

Go to the columns tab, scroll across to the right until you find the missing column heading. You can set the missing field action in this column.

kcbland wrote:Use replace option and use replacement value of something like "XXXXYYYYYZZZ" or something very noticeable and unlikely to appear in the missing column. Then, put a constraint on the following transformer to place the rows that have that column value in your reject file.

And here I was thinking, when I first saw that question, that you can't really do something like that very easily! Interesting approach, Ken.

You could have gone with 'XYZZY' as the replacement value. That perhaps, or 'PLUGH'.