BookmarkSubscribe
Choose Language Hide Translation Bar
jump
Community Trekker

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Jeff_Perkinson
Community Manager Community Manager

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 1
Highlighted
Jeff_Perkinson
Community Manager Community Manager

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