Hi all;
i am getting error like this
job1..Sequential_File_0.DSLink2: read_delimited() - row 1, too many columns in record.
what might be the problem. please suggests me
Initially i had 47 columns in source (tab delimited file). when i view the data using sequential file (source), i can able to view the data. but my 'project 'architect' changed the input file, to 49 columns. so when i view wthe data for this i am getting above error.
Thanks for ur help
Getting warning message in viewing data in source
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 2
- Joined: Mon Apr 18, 2005 3:50 am
All,
I got this message when trying to read a text file as just one long field:
RemoveSpecChars_BaseProduct..PIXP81_FTPSourceFile.clean_out: read_delimited() - row 94, too many columns in record
Now row 94 contained commas (which were not meant to be delimiters), hence the "extra" columns.
The cure was to change the following in the Format Tab:
Delimiter 000
Quote Char 000
I believe this means that there is no delimiter processing (although it is a "delimited" file). Anyway, the above fixed the problem.
Regards,
Brian
I got this message when trying to read a text file as just one long field:
RemoveSpecChars_BaseProduct..PIXP81_FTPSourceFile.clean_out: read_delimited() - row 94, too many columns in record
Now row 94 contained commas (which were not meant to be delimiters), hence the "extra" columns.
The cure was to change the following in the Format Tab:
Delimiter 000
Quote Char 000
I believe this means that there is no delimiter processing (although it is a "delimited" file). Anyway, the above fixed the problem.
Regards,
Brian