Month arranging

[tenyeapen]

HI All

can anybody please help me with arranging all the months in a list box. The month value is picking from an excel sheet. I need the list box to steady in the Jan - Dec order. Sample also attached.

[Manyao]

Hi

Add the following to your Load Statement

MONTH_VIEW:
LOAD * INLINE [
[Approved Month], MONTH_INDEX
January, 01
February, 02
March, 03
April, 04
May, 05
June, 06
July, 07
August, 08
September, 09
October, 10
November, 11
December, 12
];

Then sort by Month_index in your list

[MindaugasBacius]

Use an Inline before the whole script. Then drop the table.
sort_month:
LOAD * INLINE [
Approved Months
January
...
December
];

Drop Table sort_month;

[hopkinsc · Accepted solution]

use an inline load in the beginning of the load script (after variables). give it the same field name, then drop at the end of the script. once reloaded, change the sort order to 'Load Order'

MonthSort:

load * inline [

Approved Month

January

February

March

April

etc

]

;