Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to reload qvd incrementally from multiple source(joined) table

Hi all,

To find out how incremental reload and storing into a QVD file works from the result of sql include multiple tables ( 3 tables)..

Here is the data sql what i want to do incremental reload and store;

SELECT  P1.PROMOTION_NO,

        P3.STORE_ID,

        P2.PRODUCT_NO,

        WT.DATE ,

        TRUNC(P2.UPDATE_DATETIME) as PD_UPDATE_DATETIME,

        TRUNC(P1.UPDATE_DATETIME) as PT_UPDATE_DATETIME,

        TRUNC(P3.UPDATE_DATETIME) as PB_UPDATE_DATETIME   

  FROM PROMOTION_DEFINITION P1,

       PROMOTION_DETAIL P2,

       PROMOTION_STORE P3,

       WATSONS_CALENDAR WT

WHERE P1.PROMOTION_NO = P2.PROMOTION_NO

   AND P1.PROMOTION_NO = P3.PROMOTION_NO        

   AND WT.DATE BETWEEN P1.SALE_START_DATE AND P1.SALE_END_DATE

     TABLE SUMMARIZE:

  • in  Promotion_def table  promotion_no is unique and  generated by sequence ..
  • in promotion_detail   table  later new products can be added to a promotion or existing ones can be deleted
  • in promotion_store table   later  new stores can ve added to a a promotion or existing ones can be deleted..

Note: all table have an update_datetime column.

According to informations above.. how  can i  get  only new  and updated rows  from datasource ( database).

I hope someone can explain the me.

Kind regards,

Gökhan ÇELİK

1 Reply
Not applicable

Re: How to reload qvd incrementally from multiple source(joined) table

Hi , you can apply the incremental load on the raw table extract into qvd. After that apply the transforms on the qvd what you are applying in sql query.

Community Browser