Incomplete Column

bdixon · Post by **bdixon** » Thu Mar 17, 2005 5:59 pm

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

kcbland · Post by **kcbland** » Thu Mar 17, 2005 8:18 pm

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.

bdixon · Post by **bdixon** » Thu Mar 17, 2005 10:55 pm

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

vmcburney · Post by **vmcburney** » Thu Mar 17, 2005 11:27 pm

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.

chulett · Post by **chulett** » Fri Mar 18, 2005 12:30 am

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'.