Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!