2006 Oct 07 12:47 PM
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
2006 Oct 07 12:53 PM
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
2006 Oct 07 3:55 PM
Hi
Try
Delete duplicates from itab comparing <custno> <city>....like this.
It may work.
If helpful reward points
Regards
Manas Ranjan Panda
2006 Oct 07 4:12 PM
delete adjacent duplicates from table comparing orderno cutno.
dont forget to sort the IT with the key's u compare...
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |