Sorting issue

[Anonymous]

Hi Everybody,

I am facing one sorting issue in month names.

i want it in calendar wise sorting ie: jan feb march april etc.

Attached is the screen shot for the same.

Please assist.

[alexandros17]

Use DUAL function to sort ...

[giakoum]

dual or make sure the load order is the one required

[Gysbert_Wassenaar]

I expect that your Month field contains only text values and not numeric values. Perhaps you can create that field so it contains dual values that have both a numeric value and a textual display format. Or you can try sorting by an expression like match({1} Month, 'Januari', 'Februari', ...etc.., 'December')

[avinashelite]

Hi Gaurav,

while creating the month , have both the format created i.e. text and number ....

then use dual function with that , this will solve the issue.

EG:

Load dual(month_name,month_number) as month_name

;

[hic · Accepted solution]

Then you should define your month using the Month() function. If you have the month names in a field, you can do this by defining your field by

     Month(Date#(MonthName,'MMMM')) as Month

HIC

[Anonymous]

Hi Avinash,

cloud't get you.

Please provide some examples.

[Anonymous]

Thanks Henric,

Now i got it

Cheers !!