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!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.
![Laughing :lol:](./images/smilies/icon_lol.gif)
You could have gone with 'XYZZY' as the replacement value. That perhaps, or 'PLUGH'.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers