Hello,

i have to load a csv file from SAP (tab seperated) into WebFOCUS. The problem is that the structure is not a typical flat file structure. (Content by Columns)
I will get the data in rows. In the first row are header informations, like user_id, e_mail, company, date, in the sond row are deaper informations on the contracts belonging to the company like order or contracts, currencies, materials.
In the third to n rows are the actual orders with amounts, companys, savings. Each row has the contract_id as key field to connect the rows.
I also know in which table (SQL-Server) i have to write the specific values. Has anybody an idea how such a load process shoud work??

Regards

Christian

WF is very good at working with multi-record sequential files. Unfortunately, this does not apply to CSV format.

What a work mate of mine did very recently was create a master with one field that was as long as the longest potential record and treated the CSV as a true flat file. He then ran one query for each record type and saved the output in their own tables (using a series of where statements to identify the different record types). He then created one master for each record type to read only those records as CSVs.

This will only work if there is something in each record that can point to the parent record.

Could you post an example of the file contents?

Hi Danny,

do you mean the description of the CSV File, or a real example of the content of the CSV File??
Thanks a lot

Christian

Hi dhagen,
thanks a lot for your help. Can you give me an example. I think this is more than beginner stuff!!!!

Regards

Christian