error in sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Thu Feb 03, 2005 1:05 am
error in sequential file
Hi all,
i am using a sequential file to extract data from a text file which uses a delimiter to seperate the data.I am getting the error below.To my knowledge all the settings are right,but still i am facing this issue.Can anyone guide me.
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 81, column JOBNAME, required column missing
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 82, column JOBNAME, required column missing
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 83, column JOBNAME, required column missing
i am using a sequential file to extract data from a text file which uses a delimiter to seperate the data.I am getting the error below.To my knowledge all the settings are right,but still i am facing this issue.Can anyone guide me.
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 81, column JOBNAME, required column missing
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 82, column JOBNAME, required column missing
TIMEDETAIL_SRC..Sequential_File_0.DSLink3: nls_read_delimited() - row 83, column JOBNAME, required column missing
Based on the error that you have given it would appear that there are some rows that either have too many delimitters or not enough. Usually this happens when the delimitter you have chosen is found within the data itself.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 26
- Joined: Thu Feb 03, 2005 1:05 am
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 26
- Joined: Thu Feb 03, 2005 1:05 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 26
- Joined: Thu Feb 03, 2005 1:05 am
Hi sainath,
my data was like this aaaaa,bbbbbb with two columns only but many records.when i tried to open the coloumn it gave me an error .but when i used MaheshKumar Sugunaraj solution it got solved.
But one of friend has got the same problem i have tried MaheshKumar Sugunaraj solution he is not getting it. Any solutions appereciated.
my data was like this aaaaa,bbbbbb with two columns only but many records.when i tried to open the coloumn it gave me an error .but when i used MaheshKumar Sugunaraj solution it got solved.
But one of friend has got the same problem i have tried MaheshKumar Sugunaraj solution he is not getting it. Any solutions appereciated.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom