question about load order

[Anonymous]

Hi,

I'd like to change the order of values in the field Brand while loading the data from the source table. I need to set an alphabetical order of brands while loading the field Brand. How is that possible?

Larisa

[rubenmarin]

Hi Larisa, in the Sort tab you can set the order of any chart.

Anyway, if you want the load order in QV to be by Brand you can do:

Excel:

LOAD Brand,

     [Cost RUB],

     F3,

     F4

FROM

[.\brand_data2.xlsx]

(ooxml, embedded labels, table is data);

Data:

NoConcatenate LOAD * Resident Excel Order By Brand;

DROP table Excel;

[Anonymous]

I did as suggested. Then I created a list-box and set the load order for this list-box. But I see that the load order is not alphabetic. See the file attached.

[rubenmarin · Accepted solution]

OK, as it is the same field, the loading sort order for Brand is set in the first load, you can try with:

Source1:

LOAD Brand as Brand_Orig,

    [Cost RUB]

FROM

.\brand_data2.xlsx

(ooxml, embedded labels, table is data)

;

Data1:

NoConcatenate LOAD Brand_Orig as Brand, [Cost RUB] Resident Source1 Order By Brand_Orig

;

DROP table Source1;

This way the load order of Brand_Orig don't mess with the load order of Brand.

[awhitfield]

Hi Larisa,

you list box is set to load order, set it to Text A-Z

Andy