Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to order a qvd file by two fields, but it seems impossible. I'm sure, I'm making some mistakes but I don't know where.
See below:
MYTABLE:
LOAD MyField,
MyfieldSequence
FROM
[..\..\..Myfolder\Mytable.qvd]
(qvd) ;
Mytable1:
NoConcatenate
load *, 1 as newflag
resident MYTABLE order by Myfield asc, MyfieldSequence desc;
drop table MYTABLE;
It's very simple, but I don't see my data listed in the right order.
Help please !!
Hi
Get thru the properties "Sort" and tick the sort by load order "original "
Christian
Hi Christian, thanks for your answer.
I would sort data in the script without using sort properties tab in my objects.
Is it possible ?
try this
firstly load your table
MYTABLE:
LOAD MyField,
MyfieldSequence
FROM
[..\..\..Myfolder\Mytable.qvd]
(qvd) ;
load
MyField,
MyfieldSequence
resident MYTABLE
order by Myfield asc, MyfieldSequence desc;
load
MyField,
MyfieldSequence
resident MYTABLE;
drop table MYTABLE;
i can't get you exactly if you attached data file then i understand clearly....
hi
try this, hope it helps you.
tab1:
LOAD myfield,
myfieldseq
FROM
(ooxml, embedded labels, table is Sheet1);
tab2:
NoConcatenate
load *, RecNo() as newflag
resident tab1 order by myfield asc, myfieldseq desc ;
drop table tab1;
Yes I understand,
It seems you sort is right but to see how exactly it is loaded you have to display and sort it by original load order.
When then you checked it is well loaded you are sure you can work in your script on a table sorted as you want. For example, you can you previous, peek...
Christian