DISTINCT VALUES IN COLUMN

[Former Member]

I HAVE A COLUMN LIKE THIS:

111111

111111

222222

222222

333333

333333

I WANT TO GET THIS ONLY 1 TIME?

THANKS.

[Former Member]

I HAVE A COLUMN LIKE THIS:

111111

111111

222222

222222

333333

333333

I WANT TO GET THIS ONLY 1 TIME?

THANKS.

[Former Member]

Dear Liat,

You have not been very much clear.

What I gathered is that you are retreiving values from table with a column having those values. You can achieve with DISTINCT function of OpenSQL.

Eg: SELECT DISTINCT( field )

FROM table.

regards,

Deva.

[Former Member]

use select distinct

in your select query...

vijay

[Former Member]

after select if you want to do then...

delete adjacent duplicates by comparing field.

if you want to filter in select level

then use select distinct field

from mara

into itab.

thanks

vijay

[Former Member]

sorry , this is internal table

[Former Member]

Hi Liat,

1. DELETE ADJACENT DUPLICATES.

(see F1 help on this command )

2. try this code (just copy paste)

REPORT abc.

DATA : BEGIN OF itab OCCURS 0,

f(10) TYPE c,

END OF itab.

itab-f = '11111111'.

APPEND itab.

itab-f = '11111111'.

APPEND itab.

itab-f = '11111111'.

APPEND itab.

itab-f = '2222222'.

APPEND itab.

itab-f = '2222222'.

APPEND itab.

itab-f = '2222222'.

APPEND itab.

itab-f = '33333333'.

APPEND itab.

itab-f = '33333333'.

APPEND itab.

itab-f = '33333333'.

APPEND itab.

itab-f = '33333333'.

APPEND itab.

write 😕 '------ Before Delete Adjacent'.

LOOP AT itab.

WRITE 😕 itab-f.

ENDLOOP.

*----

---

sort itab by f. "------ IMPORTANT

delete adjacent duplicates from itab.

write 😕 '------ AFTER Delete Adjacent'.

LOOP AT itab.

WRITE 😕 itab-f.

ENDLOOP.

I hope it helps.

regards,

amit m.

Message was edited by: Amit Mittal

Message was edited by: Amit Mittal

[Former Member]

then you can use

sort itab by field1.

DELETE ADJACENT DUPLICATES FROM ITab COMPARING field1.

try this..

vijay