At 12:42 PM 12/15/2008, Hans Manhave/Jackson-Lloyd wrote:
When using LOAD to import a CSV file I receive an error 32 times.
The error is: '-ERROR- Incorrect number of values for this table ( 118)'
Is there an quick way to figure out on which rows these errors happen?
Hans,
Here's how:
01. At the R> Prompt:
SET LINES 0
LIST TABLE tablename
Note the list of columns, exact sequence and data type
02. Open the CSV file in R:BASE or any Text Editor
Compare the sequence and type of data
03. When using the LOAD command, DO NOT include the data for
computed column(s), if defined.
Hope that gives you some blues clues ...
Very Best R:egards,
Razzak.
