Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a field to group times like:
Until 3 Months
Until 6 Months
Until 10 Months
Until 1 Year
Until 1,5 Year
I need to order it in this order on Multi Selecion object and in a chart.
Someone can help me?
Thank you
If your load order is like above, I think you can just use load order as sort order.
Another option is to create dual values for each field value, with a text and a numerical representation. Use the numerical representation for sort order.
Like
LOAD dual(FIELD,recno()) as FIELD
INLINE [
FIELD
Until 3 Months
Until 6 Months
...
];
If your load order is like above, I think you can just use load order as sort order.
Another option is to create dual values for each field value, with a text and a numerical representation. Use the numerical representation for sort order.
Like
LOAD dual(FIELD,recno()) as FIELD
INLINE [
FIELD
Until 3 Months
Until 6 Months
...
];
One more option would be , simply load your information in line table with the order you want to sort and you may also drop the line table at the end of the script. You can now sort the field in multi box using Load order.i.e Right Clik on MultiBox--> Properties-->Sort Tab-->Sort By "Load Order"
Hope this helps you.
-Sridhar