Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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;
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.
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.
Hi Larisa,
you list box is set to load order, set it to Text A-Z
Andy