Query on a file

[Former Member]

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

[former_member194669]

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®

[babu_kilari4]

Yes.

GUI_DOWNLOAD would do your purpose.

Thanks,

Babu Kilari