topic Re: how to store table into QVD file in QlikView

how to store table into QVD file

madhubabum — Fri, 03 Jul 2015 07:16:42 GMT

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

Re: how to store table into QVD file

alexandros17 — Fri, 03 Jul 2015 07:19:02 GMT

Try with

STORE store * from Table2 INTO Table2.qvd;

Let me know

Re: how to store table into QVD file

Anonymous — Fri, 03 Jul 2015 07:24:43 GMT

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

Any error ?

Thanks

BKC

Re: how to store table into QVD file

jonathandienst — Fri, 03 Jul 2015 07:26:43 GMT

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

Re: how to store table into QVD file

jagan — Fri, 03 Jul 2015 07:27:07 GMT

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.

Re: how to store table into QVD file

Fri, 03 Jul 2015 07:58:29 GMT

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

Re: how to store table into QVD file

madhubabum — Fri, 03 Jul 2015 08:04:59 GMT

Hi Thanks Jagan Mohan

Re: how to store table into QVD file

madhubabum — Fri, 03 Jul 2015 08:07:10 GMT

Hi Jonathan Dienst

Thanks For your reply.....

Itz working

Thanks

Madhu

Re: how to store table into QVD file

jagan — Fri, 03 Jul 2015 08:15:02 GMT

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.

Re: how to store table into QVD file

Siva_Sankar — Fri, 03 Jul 2015 08:27:16 GMT

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'

Re: how to store table into QVD file

stephenedberkg — Fri, 03 Jul 2015 08:38:03 GMT

store [TableName] into Path .qvd

Store sales into D:\Sales.qvd