Reading .csv file.

[sagar deshmukh]

Code: Select all

I am FTPing .csv file from remote server and then concatiating it to a "R.csv" file, but when i am trying to read that "R.csv" file by using sequential stage data stage is reading just 1st row and its giving warning as "nls_read_delimited" row -1, too many column in a record"

but my data is fine can you please tell me the solution>?

R.csv---->

'99999','BB1','12/17/2008','10:01:04','000015451900110042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900210042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900310042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900410042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900510042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900610042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900710042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900810042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451900910042500000','0.15','1'
'99999','BB1','12/17/2008','10:01:04','000015451901010042500000','0.15','1'

[chulett]

Your metadata defined in the Sequential stage does not match the actual file's data. Details please - how many columns did you define? What column delimiter? Etc.

[ray.wurlod]

How many columns are mentioned in the Sequential File stage in your job design?

When you say "concatenate" to R.csv, is the already existing structure of R.csv compatible with the added rows?