Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Query on a file

Former Member

‎2009 Apr 24 9:51 PM

0 Likes
445

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

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

Reply
2 REPLIES 2
Read only

former_member194669
Active Contributor

‎2009 Apr 25 1:58 AM

0 Likes
429

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®

Read only

Former Member

‎2009 Apr 25 8:17 AM

0 Likes
429

Yes.

GUI_DOWNLOAD would do your purpose.

Thanks,

Babu Kilari