reading data from Execl file

[sri75]

HI,

I saved excel file as CSV file and reading it from sequential file stage

I got below error

test_excel..Sequential_File_0.DSLink5: read_delimited() - row 38, column ENDDATE, required

I checked 38 th record in the file.there is no value in the last column 'ENDDATE'.
when I add the value to this column , it worked fine.

also I checked some other record , it also doesn't have the value for the last column, but it didn't give any error.
Do I need to take care of this column in sequential file or in original excel file.I think our client entered values in these files manually

Please help me


Thanks

[DSguru2B]

Thats the problem with excel sheets. If nothing is entered in the column, while the export to csv, you wont see the last column. Try with different setting of "Incomplete Column" for the last column in the column's tab of the sequntial file stage. That should do the trick.

[mctny]

Another advise would be add a dummy column as a last column in your spreadsheet write a value in it and copy to all the other rows. when you read the file you can ignore this last column or you can drop it in the first transformer in your job. that will help also for a lot of other problems you might accross in reading sequential files.

[sri75]

Hi DsGuru adn Cetin

both 'settings of 'incomplete coulmn' and adding dummy column to the files worked fine.

Thanks for your suggestions

[DSguru2B]

Adding a dummy column is manual work and may not work while automating your process. A food for thought

[ganesh123]

Time to mark your topic RESOLVED