How to implememt Incremental load in qlikview?

[#1]

Hi Team,

I have a product table (oracle database)

product table contains below columns

product id

product name

product type

revenue

Now i want to implement incremetal load on above table how to write script  please help me

Thanks

chagant

[#2]

Hi,

In that table any date fields are there

[#3]

Hi Nirmal,

There is no Date column(like modifcation date )

Product id is the Pk column

i need some script

thanks

[#4]

Can you upload your sample application

[#5]

Hi nirmal i wrote the below script

A:

SELECT productid,

      productname,

      producttype,

      revenue
FROM Product;
Concatenate LOAD
       productid,

      productname,

       producttype,

      revenue
     
      from
     (qvd)
    
      WHERE NOT exists([productid])    
;
    
STORE A into (qvd);

[#6]

Ya its correct only then whats the problem

[#7]

if i load first time 20000 records are loaded

if i load second time again 20000 records loaded

then what is the use of incremental load

if i load second time only new records loaded for according to incremental concept

this is the my issue

thanks

[sushil353]

According to your script.

It will load only those ID's which were not present in the already loaded data.

which is something like insert only statement.

HTH

Sushil

[#9]

Then Try This use distinct in script like this find below,

A:

Load Distinct

SELECT productid,

      productname,

      producttype,

      revenue
FROM Product;

Concatenate

LOAD Distinct
       productid,

      productname,

       producttype,

      revenue
     
      from
     (qvd)
    
      WHERE NOT exists([productid])    
;
    
STORE A into (qvd);

[#10]

o