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