Custom sorting

[#1]

Hi,

I have this column that consists of the given set of values

I want it to be sorted as

0

1

2

3

4-7

8-15

16-30

31-60

60+

How to do this? Please help

[yavoro]

I would use match function, so your sort order condition should be something like:

match(columnName,'0','1','2','3','4-7','8-15','16-30','31-60','60+')

Give it a try

Cheers

[MayilVahanan]

HI

Try with dual function in script itself.

or

match(columnName,'0','1','2','3','4-7','8-15','16-30','31-60','60+') in sort expression

[Clever_Anjos]

Use a dual, example below:

LOAD dual(F1,RowNo()) as F1 INLINE [

    F1

    0

    1

    2

    3

    4-7

    8-15

    16-30

    31-60

    60+

];