Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadmundewadi
Contributor III
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?

1 Solution

Accepted Solutions
Anonymous
Not applicable

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);

View solution in original post

2 Replies
Anonymous
Not applicable

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
Contributor III
Contributor III
Author

Perfect. Thank you!