Hi
please could any one help me in this following issue.
Input file with || format
a||b||c||d||e
1||2||3||4||5
g||g||e||6
in 3rd row after 6 there is missing || Following is small job
Sequential File Stage---->Transformer------>Sequential File
|
|
|
Reject
In Reject file i am able to see the 3rd row of the file i.e the record with missing || in single Column, but the requirement say record should go further for business process. please could u help how can i get that record process. This is a parallel job.
Thanks
Missing delimiter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read the file using a single VarChar field and parse it in a downstream Transformer stage, wherein you can handle the missing column appropriately (supply a default value?).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 84
- Joined: Sat Jul 19, 2008 8:50 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Pick up the rejects in the Sequential File stage with a reject link, reparse it (Column Import stage perhaps), generate the default value for the missing field (Column Generator stage perhaps) and funnel the two sets of rows back together.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.