Sort and then store to QVD

[prasadmundewadi]

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?

[Anonymous · Accepted solution]

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]

Perfect. Thank you!