issue using sequential file

times29 · Post by **times29** » Wed Jul 17, 2013 9:16 am

Hi,
I have data which looks like below in xls file, i am using sequential file to view data

Properties are:
Record level none
Feild defaults
delimiter none
Quote none

I can see company_tcd data as meesed up and doc_num as all null

COMPANY_TCD DOC_NUM
1000 3000012010
1000 3000012010
1000 3000012010
1000 3000012010
1000 3000012010

Any idea what i should set properties too.

Thanks

ArndW · Post by **ArndW** » Wed Jul 17, 2013 9:47 am

Is this a .xls Excel file or an Excel as a .csv or text file? If the first then you need to use ODBC to read the file.

times29 · Post by **times29** » Wed Jul 17, 2013 11:26 am

I converted it to .csv still same issue

chulett · Post by **chulett** » Wed Jul 17, 2013 11:51 am

Your metadata needs to match the file format. For example, in a "csv" file you'll need to tell it the field delimiter is a comma. Since you haven't, everything goes into the first column.