how to store table into QVD file

[madhubabum]

Hi all

How can we store the .QVD file   <= '09/28/2014 date

Temp:

LOAD

    YearNumber,

    MonthText,

    WeekNumber,

    DateTimeCreated,

    date(floor(DateTimeCreated),'MM/DD/YYYY') as Date,

    DateTimeModified;

SQL SELECT YearNumber,

    MonthText,

    WeekNumber,

        DateTimeCreated,

    DateTimeModified

FROM Source

WHERE metricidentkey='{xxxxxxxxxxx}'

AND YearNumber >='2011';

Table2:

load *  Resident Temp

where Date <= '09/28/2014';

STORE Table2 INTO [Table2.qvd] (qvd);

[alexandros17]

Try with

STORE store * from Table2 INTO Table2.qvd;

Let me know

[Anonymous]

seems You are using the correct syntax then what problem you are facing ?

Any error ?

Thanks

BKC

[jonathandienst]

Table2 will auto-concatenate into Temp, so nothing will be saved in the QVD. You need:

Table2:

noconcatenate

load *  Resident Temp

where Date <= '09/28/2014';

STORE Table2 INTO [Table2.qvd] (qvd);

[jagan]

Hi,

What is the issue you are facing?   If data is not storing in the QVD then use the where condition like below

Table2:

NoConcatenate

load *  Resident Temp

where Date <= Date('09/28/2014');

Regards,

Jagan.

[#6]

madhubabuM , Just want to add that, if two or more tables have same fields (same number of columns with same names), QlikView will automatically concatenate them into a single table, with the name being the first table name. To overcome this behavior, Load statement has to be prefixed with NoConcatenate to avoid the auto concatenation.

In your case, after Table2 load has been executed, it will be concatenated with Temp table. So there will be no Table2 available. Because of this your ​STORE Table2 INTO [Table2.qvd] (qvd); ​didn't work.

Regards,

KKR

[madhubabum]

Hi Thanks Jagan Mohan

[madhubabum]

Hi Jonathan Dienst

Thanks For your reply.....

Itz working

Thanks

Madhu

[jagan]

Hi Madhu,

If you got the answer please close this thread by giving Correct answer to the reply which helped you, so that other users can find the correct answers easily.

Regards,

Jagan.

[Siva_Sankar]

Case 1:

If you want to store the data for year greater than 2011 and  year greater than '09/28/2014' into two separate QVDs then:

Temp:

LOAD

    YearNumber,

    MonthText,

    WeekNumber,

    DateTimeCreated,

    date(floor(DateTimeCreated),'MM/DD/YYYY') as Date,

    DateTimeModified;

SQL SELECT YearNumber,

    MonthText,

    WeekNumber,

        DateTimeCreated,

    DateTimeModified

FROM Source

WHERE metricidentkey='{xxxxxxxxxxx}'

AND YearNumber >='2011';

STORE TempINTO [Temp.qvd] (qvd); // Temp.qvd will have all the data from year 2011

Noconcatenate

Table2:

load *  Resident Temp

where Date <= '09/28/2014';

STORE Table2 INTO [Table2.qvd] (qvd);//Table2.qvd will have the data only from '09/28/2014'