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);


1 comment:

  1. Your site about Incremental loading in qlikview is just like an online guide that is very helpful for the Qlikview learners, thanks for the useful data. QlikView Training in Hyderabad

    ReplyDelete