BookmarkSubscribeRSS Feed
jump

Community Trekker

Joined:

Sep 13, 2014

When creating tables from a array\list? How to order it in sequence from the list and not name

When creating tables from a array\list? How to order it in sequence from the list and not name.

for eg..  list1 = {idle,slow, fast};  or put same thing column.

when i create table(using TABULATE) based on this list or column it .. changes order to alphabetic. How do i prevent that?

btw, i tried putting number in front of the Name\character... it still does not work.

thx

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

Re: When creating tables from a array\list? How to order it in sequence from the list and not name

You can use the Value Ordering column property to control the order values are shown in reports.

This property is scriptable with the Set Property() message to a column:


Column(dt, "speed")<<Set Property( "Value Ordering", {"idle", "slow", "fast"} )



-Jeff

-Jeff
1 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

Re: When creating tables from a array\list? How to order it in sequence from the list and not name

You can use the Value Ordering column property to control the order values are shown in reports.

This property is scriptable with the Set Property() message to a column:


Column(dt, "speed")<<Set Property( "Value Ordering", {"idle", "slow", "fast"} )



-Jeff

-Jeff