topic Re: Getting error while using Order by Desc in QlikView

Getting error while using Order by Desc

Wed, 30 Jul 2014 12:30:56 GMT

Hello everybody,

I have a piece of code as below

Map_SS:
Load
INVOICENUMBER,
[DATE STEP CREATED DERIVED]
FROM a.QVD(qvd)
where STEPNAME='Complete PeopleSoft Process' order by [DATE STEP CREATED DERIVED] desc;

DATE_STEP_CREATED_DERIVED:

Mapping LOAD * Resident Map_SS;
drop table Map_SS;

While loading it is giving an error message stating Garbage after statement.

Could anyone please help me how to use Order by desc here?

Thanks in Advance

Sonali

Re: Getting error while using Order by Desc

michael_maeuser — Wed, 30 Jul 2014 12:32:20 GMT

order by does only work in resident load

Re: Getting error while using Order by Desc

michael_maeuser — Wed, 30 Jul 2014 12:32:52 GMT

so just load your table resident and drop the original

Re: Getting error while using Order by Desc

VishalWaghole — Wed, 30 Jul 2014 12:39:46 GMT

Hi Sonali,

Order by is not working with ordinary load.

If you load it again as resident then it will work.

Like this

Map_SS:

Load INVOICENUMBER,

[DATE STEP CREATED DERIVED]

FROM a.QVD(qvd)

where STEPNAME='Complete PeopleSoft Process';

Load INVOICENUMBER,

[DATE STEP CREATED DERIVED]

Resident Map_SS

order by [DATE STEP CREATED DERIVED] desc;

-- Regards,

Vishal Waghole

Re: Getting error while using Order by Desc

its_anandrjs — Wed, 30 Jul 2014 12:40:33 GMT

Order by clause will work only in the resident table then try like

Temp_Map_SS:
Load
INVOICENUMBER,
[DATE STEP CREATED DERIVED]
FROM a.QVD(qvd);

Noconcatenate

Map_SS:

Load
INVOICENUMBER,
[DATE STEP CREATED DERIVED]

Resident Temp_Map_SS

where STEPNAME='Complete PeopleSoft Process' order by [DATE STEP CREATED DERIVED] desc;

Drop Table Temp_Map_SS;

DATE_STEP_CREATED_DERIVED:

Mapping LOAD * Resident Map_SS;
drop table Map_SS;

Re: Getting error while using Order by Desc

michael_maeuser — Wed, 30 Jul 2014 12:42:07 GMT

see first answer...

Re: Getting error while using Order by Desc

its_anandrjs — Wed, 30 Jul 2014 12:44:00 GMT

HI Sonali,

And another way for this is in resident load make the table as Mapping table see the script below and try this code also.

Temp_Map_SS:
Load
INVOICENUMBER,
[DATE STEP CREATED DERIVED]
FROM a.QVD(qvd);

Noconcatenate

DATE_STEP_CREATED_DERIVED:

Mapping Load
INVOICENUMBER,
[DATE STEP CREATED DERIVED]

Resident Temp_Map_SS

where STEPNAME='Complete PeopleSoft Process' order by [DATE STEP CREATED DERIVED] desc;

Drop Table Temp_Map_SS;

Re: Getting error while using Order by Desc

Wed, 30 Jul 2014 12:58:25 GMT

Thank You All For Your Reply....

Re: Getting error while using Order by Desc

VishalWaghole — Wed, 30 Jul 2014 12:59:31 GMT

Most Welcome Sonali