Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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