topic Re: QVD in QlikView

QVD

noman212 — Wed, 27 Aug 2014 06:41:11 GMT

Hello Tigers,

I load data from oracle for the year of 2013 and 2014 and store it into QVD, in oracle database records are inserted on daily basis i have date feild to check the updated data . i load data for the year of 2013,2014 from qvd then i load data on sysdate ( i.e. today) data from query and concatenate it and store in qvd.but the size of qvd increases and duplication occurs. here is the following script i use for this purpose

what is the solution of this problem and incoorect records.

Input:

Load

channel,

Premium,

proposal,

CalendarDate,

CalendarYearStart,

CalendarYearEnd,

CalendarMonthName,

CalendarYear

FROM (qvd);

Input:

Load

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

SQL

Select A,B,C,D From Input where D = trunc(sysdate)

Concatenate

LOAD

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

From

C:\input.qvd (qvd);

store Input into C:\input.qvd (qvd);

Regards.

Re: QVD

AbhijitBansode — Wed, 27 Aug 2014 06:50:34 GMT

Please see the thread :

http://community.qlik.com/message/473712#473712

Re: QVD

ashfaq_haseeb — Wed, 27 Aug 2014 06:54:37 GMT

Hi,

Try this

Input:

Load

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

SQL

Select A,B,C,D From Input where D = trunc(sysdate)

Concatenate

LOAD

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

From

C:\input.qvd (qvd);

store Input into C:\input.qvd (qvd);

Regards

ASHFAQ

Re: QVD

Wed, 27 Aug 2014 06:59:28 GMT

Hi,

Use Exists function with Primary Key field value.

Re: QVD

noman212 — Wed, 27 Aug 2014 07:09:10 GMT

Ashfaque it occurs Duplication again. when i perform reload 1st time its show me count 153 i again perform reload it shows 306

Re: QVD

noman212 — Wed, 27 Aug 2014 07:09:50 GMT

Hi,

Pls give me example script from where i can apply this exist function

Re: QVD

ashfaq_haseeb — Wed, 27 Aug 2014 07:14:43 GMT

Hi,

In this case use below

Try this

CurrentDay:

Load

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

SQL

Select A,B,C,D From Input where D = trunc(sysdate)

store CurrentDay into CurrentDay.qvd(qvd);

Drop table CurrentDay;

Then simple use below in end user application.

Input

LOAD

A as channel,

B as InputPremium,

C as proposal,

D as CalendarDate,

YearStart(D) as CalendarYearStart,

YearEnd(D) as CalendarYearEnd,

Month(D) AS CalendarMonthName,

Year(D) AS CalendarYear ;

From

C:\input.qvd (qvd);

concatenate

LOAD

channel,

InputPremium,

proposal,

CalendarDate,

CalendarYearStart,

CalendarYearEnd,

CalendarMonthName,

CalendarYear ;

From

C:\CurrentDay.qvd (qvd);

If you want to store the above in input.qvd, then you have to go for incremental reload.

Regards

ASHFAQ

Re: QVD

noman212 — Wed, 27 Aug 2014 07:18:35 GMT

Thanks for the help Ashfaque pls give me any tutorial for incremental load if possible.

Re: Re: QVD

ashfaq_haseeb — Wed, 27 Aug 2014 07:22:22 GMT

Hi,

Start from here

look at below post too.

Re: Incremental load

Regards

ASHFAQ