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
Showing results for 
Search instead for 
Did you mean: 
Read only

redundant data

Former Member
0 Likes
505

by writing delete duplicates i m loosin the whole row data. i want something like all the order no.s 2 b displayed (these r unique) n the custno,city,country etc redundant data 2 b screened off.

suggest me the solution as soon as possible.

regards

nagaveni

by writing delete duplicates i m loosin the whole row data. i want something like all the order no.s 2 b displayed (these r unique) n the custno,city,country etc redundant data 2 b screened off.

suggest me the solution as soon as possible.

regards

nagaveni

3 REPLIES 3
Read only

Former Member
0 Likes
472

If ur sorting by customer no,do one thing use event on change of customer no and in that do the required things.

Let me know if I did not understand ur requirement clearly.

Regards

Read only

Former Member
0 Likes
472

Hi

Try

Delete duplicates from itab comparing <custno> <city>....like this.

It may work.

If helpful reward points

Regards

Manas Ranjan Panda

Read only

Former Member
0 Likes
472

delete adjacent duplicates from table comparing orderno cutno.

dont forget to sort the IT with the key's u compare...