How to Upload a txt file with header

[Former Member]

Hi ,

I have a file on the presentation server

with Header information and then data records,

EX:

Material 37/2008 38/2008 39/2008 40/2008

12345 100 120 130 140

12346 100 120 130 140

12347 100 120 130 140

I need to upload this data into two internal tables.

One for the data in the first row and

second internal table for all the remaining data records.

Thanks

Kiran

[naimesh_patel]

Upload the file in one Temporary table and than split your records in header and data tables as per the requirements.

Regards,

Naimesh Patel

[Former Member]

Hi,

While looping at the table obtained from the data in the flat file.

Whenever you find "Material" in the first field (as per your record structure you have speficied),

Consider that row to be header and split & append this record to your header internal table.

Rest of the records, move into second internal table (item) using split and append.

Thanks,

Kartavya

[Former Member]

Thanks