read delimited: required Column missing - Urgent
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing - Urgent
My job design is
Seq -> link Partitioner ->Link Collector -> Seq -> Transformer - hash/Seq
I am getting error in 2nd Seq file (CSV file) stage while moving data to transformer. I am getting error message " read delimited: ron 1 "Column name" required column missing.
I have the delimiter in input and output of Seq file stage and both are pipes. This is not the last column.
Below is the error when I changed the attribute to replace.
The Incomplete column value of Column "Column Name"must have values in ascending order.
Seq -> link Partitioner ->Link Collector -> Seq -> Transformer - hash/Seq
I am getting error in 2nd Seq file (CSV file) stage while moving data to transformer. I am getting error message " read delimited: ron 1 "Column name" required column missing.
I have the delimiter in input and output of Seq file stage and both are pipes. This is not the last column.
Below is the error when I changed the attribute to replace.
The Incomplete column value of Column "Column Name"must have values in ascending order.
Vignesh Kumar N
So... you have this error reading the file you just wrote? First triple-check and make sure your file pathnames, options and column metadata match. And undo your 'Incomplete Column' attribute change, it doesn't work that way.
ps. It's not urgent.
ps. It's not urgent.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
Ok chulett. I have checked the path, metadata etc. Everythink looks fine. I have changed the Incomplete column action to Error. Please advice now.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
I am able to see the solution provided by you on Tue Nov 17, 2009 10:49 am in other post for the same issue. Since I am not a premium member, I am not able to read completely. if possible could you please update the same in this post also. Thanks in advance!!!
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
I viewed the data in Datastage and able to see difference in Input (data wrote to file) and output. Input data (data wrote to file) is looking correct and Ouput data seem to improper and junk data.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
Improper & junk data - having wrong metadata. Policy number filed is having name of the policy holder.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
Chulett, you are correct with first point. Can you explain more on this. I am having delimiter as | (pipe). I have checked both input and Ouput has same demlimiter.
Where to check the quoted string
Where to check the quoted string
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
read delimited: required Column missing
Thanks for the info provided. Issue has been resolved now by filtering policies which has wrong data.
Vignesh Kumar N