rearranging fields

[Anonymous]

hi guyz,

             i nid help.... i have a field say  A_table

             in A_table i have values 1_a, 2_b, 3_c wen i load d order is 1_a,2_b, 3_c

             Now i want to load A_table  with values in different order like 2_b, 1_a , 3_c

             how to do?

              Any help plz?

regards,

Vaibhav

[Anonymous]

You can create a separate field with the sort order and sort by expression.

For example:

Load * Inline [

F1, F2

a, 2

b, 1

c, 3

];

Sort field F1 by F2 and you will get b, a, c.

Or, you can combine them into one field using dual():

Dual(F1, F2) and then the field can be sorted numerically.

[its_anandrjs]

Hi,

Give ranking to your your fields like

1_a, 2

2_b, 1

3_c, 3

Regards,

Anand

[Anonymous]

hi jonannes,

                     thnx for the quick reply but m not able to do.

                      i have a table feild n m not using any inline....plz help

[its_anandrjs]

Hi,

Create another Load order table and add field Order with numbering 2,1,3 to field

loadOrder:

load * inline

[

A_table,Order

1_a, 2

2_b, 1

3_c, 3

];

and after that in the properties of the object in Sort tab -> in expression select =Order field and make sort by tis order

HTH

Regards,

Anand

[Anonymous]

hi anand,

                  How to do tat in script?

[Anonymous]

hi anand,

                  Everythng as to be in d script.

[Anonymous]

Any one can help plzzzzzzzzzzz