Hi,
Can you give a unix command to delete a particular row from a file.
I will delete this row and try running. so that i can confirm whether problem lies only in this record or i am missing something else.
Read_delimited() – row 1198231,column DEPT, required column
Moderators: chulett, rschirm, roy
Is row 1,198,231 the last row in the file?
Anyway you can do this.
1. $ head -n 1198230 <inputfilename> > <outputfilename>
This will give you all the rows except the one that it fails on.
If after running, this does work, then you have badly a delimited file, where one of the columns hasnt got a comma, hence getting the error message
Anyway you can do this.
1. $ head -n 1198230 <inputfilename> > <outputfilename>
This will give you all the rows except the one that it fails on.
If after running, this does work, then you have badly a delimited file, where one of the columns hasnt got a comma, hence getting the error message
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Within the Columns grid in the Sequential File stage you can scroll right and find a place where you can set up a "missing value" rule. Try changing that rule for DEPT to Replace, so that the job does not fail.
But, yes, you do need to check the file itself and verify whether there are too few delimiters in the line in question.
But, yes, you do need to check the file itself and verify whether there are too few delimiters in the line in question.
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.
You need to not be removing lines and instead determine the exact nature of the problem and if it is possible to read the file properly. Some badly formated delimited files can be... problematic and should be returned to sender.
Otherwise, these turn out to be 'normal' issues you need to learn how to handle. How about posting some sample lines from the file? Good ones and then problem children as well. Posting the current version of your error(s) would help as well.
![Wink :wink:](./images/smilies/icon_wink.gif)
Otherwise, these turn out to be 'normal' issues you need to learn how to handle. How about posting some sample lines from the file? Good ones and then problem children as well. Posting the current version of your error(s) would help as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers