Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
prasadmundewadi
New Contributor III

Sort and then store to QVD

Hi

I want to sort my data by snapshot date and then store it to QVD. There are total of 7 columns in the table.

Here is my load script:

Table1:

Load SnapshotDate, Col1,Col2...Col6 from Table1

Table2:

Load * Resident Table1 Order by SnapshotDate desc;

Store Table2 into [$(Path)QVD_name.qvd] (qvd);

--------------------------------------------------------------------------------

When I run the load it throws error as 'Table2 not found'.

There are total of 7 columns in the table. Instead of 'Load * Resident Table1' If I list any 6 columns I don't get error. I cannot figure out why is this happening? Can somebody explain?

Tags (1)
1 Solution

Accepted Solutions

Re: Sort and then store to QVD

As the field names will all the same it will auto concatenate.  Add a NoConcatenate to prevent this.

Table1:

Load SnapshotDate, Col1,Col2...Col6 from Table1

Table2:

NoConcatenate

Load * Resident Table1 Order by SnapshotDate desc;

Store Table2 into [$(Path)QVD_name.qvd] (qvd);

2 Replies

Re: Sort and then store to QVD

As the field names will all the same it will auto concatenate.  Add a NoConcatenate to prevent this.

Table1:

Load SnapshotDate, Col1,Col2...Col6 from Table1

Table2:

NoConcatenate

Load * Resident Table1 Order by SnapshotDate desc;

Store Table2 into [$(Path)QVD_name.qvd] (qvd);

prasadmundewadi
New Contributor III

Re: Sort and then store to QVD

Perfect. Thank you!