topic Re: Query on a file in Application Development and Automation Discussions

Query on a file

Former Member — Fri, 24 Apr 2009 20:51:31 GMT

Hi All,

I will be getting a file from local pc . The file conatins 5 fileds . Out of these 5 fileds

i have to consider filed1 unique values . Based on these unique values i have to get field2 values .

I dont want create a DB table for this req . Please let me know << Removed >>.

Edited by: Rob Burbank on Apr 24, 2009 5:07 PM

Re: Query on a file

former_member194669 — Sat, 25 Apr 2009 00:58:39 GMT

Hi,

1. Use fm GUI_UPLOAD and upload local pc file into internal table

2. For example if your internal table contains field as


data : begin of itab occurs 0.
data : field1(10) type c..
data : field2(10) type c.
data : field3(10) type c..
data : field4(10) type c.
data : field5(10) type c..
data: end of itab.

After upload


sort itab by field1.
delete adjacent duplicates from itab comparing field1.

Here itab contains unique valiues based on field1.

a®

Re: Query on a file

Former Member — Sat, 25 Apr 2009 07:17:20 GMT

Yes.

GUI_DOWNLOAD would do your purpose.

Thanks,

Babu Kilari