QVD

[noman212]

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.

[AbhijitBansode]

Please see the thread :

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

[ashfaq_haseeb]

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

[#4]

Hi,

Use Exists function with Primary Key field value.

[noman212]

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

[noman212]

Hi,

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

[ashfaq_haseeb]

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

[noman212]

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

[ashfaq_haseeb · Accepted solution]

Hi,

Start from here

look at below post too.

Re: Incremental load

Regards

ASHFAQ