Following is my environment
Source File: Excel
Target File : Sequential File
I save the excel file as a text file as well as a CSV file. This file has the first line as column name.
When I import the sequential file definition I set the first line as column name. If I am importing a text file then save the delimiter as a TAB. Am able to correctly view the data under define tab. But when I import the table into my sequential file and try to view the data I get the following error:
Code: Select all
<Sequential_File_32,0> Field "DATE_COL" delimiter not seen, at offset: 15
##W TOIX 000154 12:41:00(001) <Sequential_File_32,0> Import warning at record 0.
##W TOIX 000018 12:41:00(002) <Sequential_File_32,0> Import unsuccessful at record 0.
Still I get the above error.
Would appreciate if someone could explain why I am getting this error.