Thursday 24 July 2014

Incremental loading in qlikview

//Qvd_Load:
//LOAD Id,
//    Name,
//    date;
//SQL SELECT *
//FROM "Product_master".dbo.Test;
//
//Store Qvd_Load into C:\mahantesh\QlikView\Nuvento\tests\SQL_Test.qvd(qvd);
//
//drop table Qvd_Load;

Qvd_Load1:
LOAD Id,
   
Name,
   
date ;
SQL SELECT *
FROM "Product_master".dbo.Test;

Latest_Date:
LOAD date Resident Qvd_Load1 order by date desc ;

let vdate=Peek('date',0,'Latest_Date');

drop table Qvd_Load1;
drop Table Latest_Date;

Increment_load:
//LOAD * where date > $(vdate);
LOAD Id,
   
Name,
    
date;
SQL SELECT *
FROM "Product_master".dbo.Test
where date >'$(vdate)';

Concatenate
LOAD Id,
    
Name,
    
date
FROM
C:\mahantesh\QlikView\Nuvento\tests\SQL_Test.qvd
(
qvd)
where not Exists(Id);


inner join(Increment_load)
LOAD Id,
   
Name,
   
date;
SQL SELECT *
FROM "Product_master".dbo.Test;


STORE Increment_load into C:\mahantesh\QlikView\Nuvento\tests\SQL_Test.qvd(qvd);

DROP Table Increment_load;


LOAD Id,
    
Name,
    
date
FROM
C:\mahantesh\QlikView\Nuvento\tests\SQL_Test.qvd
(
qvd);