Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

how to store table into QVD file

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

10 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try with

STORE store * from Table2 INTO Table2.qvd;

Let me know

Anonymous
Not applicable

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

Any error ?

Thanks

BKC

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable

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
Creator
Creator
Author

Hi Thanks Jagan Mohan

madhubabum
Creator
Creator
Author

Hi Jonathan Dienst

Thanks For your reply.....

Itz working

Thanks

Madhu

jagan
Luminary Alumni
Luminary Alumni

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
Master II
Master II

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'