how to change the order of values in the field in script level

[#1]

hi,

I am having a filed which consists of

Name

A

B

C

D

D

but i need get them in this order

A

B

D

F

E

can we do it in script level by using the apply map can anyone help me .

thanks in advance

[#2]

Sorry i got wrong image uploaded

[#3]

my bad i am unable to understand your solution clearly.

[maxgro]

the first one is the easier (below): before loading any other table (or any table with Name field) you load (or inline load) the Name field in the order you want; this is the load order; so the load order for field Name is F E ....A

when you put the field Name in a chart you can order (sort tab) in different ways; choose load order and you get F E ....A

tmpforloadorder:

load * inline [

Name

F

E

D

C

B

A

];

table:

load * inline [

Name, Sales

D, 100

E, 100

F, 100

A, 200

B, 200

C, 100

];

drop table tmpforloadorder;