Sort Function

[#1]

hope to do the following.

i have a column whereby i show color codes, i.e

Color

20

39

40

03

12

90

i would like the colors to sort in order but have 39 always last. Alternatively i would like to use the description of 39 for the totals row. and discard 39 from the color column. As i have over 150 colors Match seems like a daunting task, is there any good code to save time in this case.

[#2 · Accepted solution]

Bradley,

If Color is a dimension, do the following:

1) LOAD INLINE

with the order you wish

Script: load your tables (incl. Color)

2) SORT by LOAD order in the UI

QV keep the first order used to populate the table. So do not delete this field during the script. And use this load order in the UI.

Fabrice

[rwunderlich]

You can actually DROP the INLINE sort table at the end of the script. The load order will be preserved through the load of your fact tables.

-Rob