topic Re: Uploading Flat file from an internal table without Header in Application Development and Automation Discussions

Uploading Flat file from an internal table without Header

Former Member — Wed, 16 Jul 2008 07:07:31 GMT

Hi All,

I am facing a problem.

I am using GUI_UPLOAD to upload tab delimited file into an internal table TBL_UPLOAD.

The flat file is having 6 fields with the header.

e.g. flat file structure

Vendor Material Porg plant DelTime PurGroup

130117 99474 8300 8340 10 100

I want to remove that header line while uploading the file to internal table.

How to do that?

Thanks and Regards,

Cooldeep

Former Member — Wed, 16 Jul 2008 07:11:15 GMT

In GUI_Upload In importing Part there is a paramerter called Header , make that one as a comment, do not pass any value there.

you will upload file without header.

With Regards

Nikunj Shah

Former Member — Wed, 16 Jul 2008 07:12:42 GMT

hiiii

you can process on internal tabel like using

DELETE it_tablename INDEX 1.

it will delete data from index 1.so header will be removed.

regards

twinkal

Edited by: twinkal patel on Jul 16, 2008 9:12 AM

Former Member — Wed, 16 Jul 2008 07:17:50 GMT

Hi Nikunj,

Thanks for your quick reply....

I am already not using HEADER parameter.

Former Member — Wed, 16 Jul 2008 07:19:55 GMT

Hi Twinkle,

As the data types of those fields are different, Uplaod will get failed because of the header.

Former Member — Tue, 22 Jul 2008 11:40:40 GMT

Hi,

If flat file has header line...then I want to delete the same or if does not then nothing to do....just uplaod the file....