Sorting Issues on Resident Table.

[#1]

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.

[vijay_iitkgp · Accepted solution]

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 ....

[#3]

Thanks Vijay..