-
Simple order by question
Ivan Troisi Feb 7, 2012 11:14 AM (in response to Ivan Troisi)Sorry.. in Resident i employed History. thank!.
Ivan
-
Simple order by question
Jason Michaelides Feb 7, 2012 12:33 PM (in response to Ivan Troisi)I think your issue is that the RESIDENT load is concatenating to the main table. Try changing your last script section to:
NoConcatenate
LOAD
bug_id,
user_id,
date_modified,
prioridad,
reabierto
Resident History
order by bug_id , date_modified, prioridad;
Store History into [C:\Repositorios\Intelmed\Mantis\L1\History];
drop table History;
Also, I don't know why you are storing to the same QVD file twice. Remove the first STORE command?
Hope this helps,
Jason
-
Re: Simple order by question
Ivan Troisi Feb 7, 2012 1:05 PM (in response to Jason Michaelides )Hi, thank very much Jason, i remove the first store, it was a mistake to copy and paste. i change my script but also it doesnt work.
My new script:
Historial:
LOAD
user_id,
bug_id,
date_modified,
prioridad,
reabierto
FROM
[C:\Repositorios\Intelmed\Mantis\L1\Cambios]
(qvd);
ConcatenateLOAD user_id,
bug_id,
date_modified,
prioridad,
reabierto
FROM
[C:\Repositorios\Intelmed\Mantis\L1\Ultimo]
(qvd);
NoConcatenateLOAD
bug_id,
user_id,
date_modified,
prioridad,
reabierto
Resident History
order by bug_id ,date_modified, prioridad;Store Historial into [C:\Repositorios\Intelmed\Mantis\L1\Historial];
Please take a look at the qvd.
Thanks in advance.
Ivan.
-
Historial 510.2 K
-
Re: Simple order by question
Ivan Troisi Feb 7, 2012 1:10 PM (in response to Ivan Troisi)I need only order by: first bug_id, second date_modified and third prioridad.
Thanks!.
Ivan.
-
Re: Simple order by question
Jason Michaelides Feb 8, 2012 3:50 AM (in response to Ivan Troisi)I think you need to declare a name for the second table load, and don't forget to drop the first. So:
Historial_temp:
LOAD
user_id,
bug_id,
date_modified,
prioridad,
reabierto
FROM
[C:\Repositorios\Intelmed\Mantis\L1\Cambios]
(qvd);
Concatenate (Historial_temp)LOAD user_id,
bug_id,
date_modified,
prioridad,
reabierto
FROM
[C:\Repositorios\Intelmed\Mantis\L1\Ultimo]
(qvd);Historial:
NoConcatenateLOAD
bug_id,
user_id,
date_modified,
prioridad,
reabierto
Resident History
order by bug_id ,date_modified, prioridad;Store Historial into [C:\Repositorios\Intelmed\Mantis\L1\Historial];
DROP TABLE Historial_temp;
Give that a go.
Jason
-
-
-
-
-
Simple order by question
Ivan Troisi Feb 8, 2012 2:08 PM (in response to Ivan Troisi)Jason, it works!.
Thank you very much.
Regards.
Ivan.
-
Re: Simple order by question
Jason Michaelides Feb 8, 2012 2:49 PM (in response to Ivan Troisi)Coolio. You're welcome.
-