topic Sorting Issues on Resident Table. in QlikView

Sorting Issues on Resident Table.

Tue, 20 Dec 2011 06:41:19 GMT

Hi,

I have a QVD file that I wanted to sort and save again to QVD, when I try the following I'm encountering issues:

Unsorted:

Load * from unsorted.qvd (qvd);

Sorted:

Load * Resident Unsorted Order By ItemNo;

Store Sorted into Sorted.qvd;

Drop Tables Unsorted, Sorted;

What's happening is if the Unsorted table contains 100 rows, when the next load is executed it is being concatenated to the Unsorted Table instead of creating the Sorted table, hence the Store is not working since it says that can't find the table Sorted.

Am I doing it the wrong way?

Thanks.

Sorting Issues on Resident Table.

vijay_iitkgp — Tue, 20 Dec 2011 06:45:16 GMT

Hi,

If 2 tables have same schema then Qlikview understand both table as same and concatenate bith.

You can use Noconcatenate keyword after table name.

Eg:

Unsorted:

Load * from abc.qvd;

Sorted:

Noconcatenate

Load

Resident Unsorted Orderby ....

Sorting Issues on Resident Table.

Tue, 20 Dec 2011 07:01:09 GMT

Thanks Vijay..