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
Incomplete Column
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
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.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.
You could have gone with 'XYZZY' as the replacement value. That perhaps, or 'PLUGH'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers