Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have requirement like below
1.I need to Create a load script that can be scheduled in the QMC to run on a nightly basis (no visualizations required) that will look for new Billing Detail files ($AppImportPath) and load them if they are new (have not yest been loaded) via QVD files.
2.The script should only load new data and only update the QVD files that need to be updated.
3.If there are no new Billing files, the script does nothing.
Can any one give me solution for the above requirement
Thanks,
Siva
1) Let's assume you have a Qvd file : Table.qvd That contains all the previously Loaded Data.
2) Let's load the new data:
MyTable:
Load * from source;
Let vNoRows=NoOfRows('MyTable');
//Load from the QVD only the lines that exists in the New source
Qvd:
Load * from Qvd where exists(ID);
Let vExists=Peek(ID',$(vNoRows)+1,'MyTable');
Let vExistsLen=Len(trim(Peek(ID',$(vNoRows)+1,'MyTable')));
//Now, if vNoRows is filled => that means that the new source contains data that exists in the QVD;
//if it's null => the new data does not exist in the QVD: new data !
if $(vExists)='NULL' or $(vExistsLen)=0 THEN
drop table MyTable;
//Import it another time and store it with the qvd (concatenate)
MyTable:
load * from source;
Qvd:
load * from Qvd where not exists(ID) ; //with update
//or load * from Qvd; insert without update
store MyTable into qvd path..
else // we don't do anything new, we just import the data in the qvd
drop table MyTable;
load * from QVD;
exit script
1) Let's assume you have a Qvd file : Table.qvd That contains all the previously Loaded Data.
2) Let's load the new data:
MyTable:
Load * from source;
Let vNoRows=NoOfRows('MyTable');
//Load from the QVD only the lines that exists in the New source
Qvd:
Load * from Qvd where exists(ID);
Let vExists=Peek(ID',$(vNoRows)+1,'MyTable');
Let vExistsLen=Len(trim(Peek(ID',$(vNoRows)+1,'MyTable')));
//Now, if vNoRows is filled => that means that the new source contains data that exists in the QVD;
//if it's null => the new data does not exist in the QVD: new data !
if $(vExists)='NULL' or $(vExistsLen)=0 THEN
drop table MyTable;
//Import it another time and store it with the qvd (concatenate)
MyTable:
load * from source;
Qvd:
load * from Qvd where not exists(ID) ; //with update
//or load * from Qvd; insert without update
store MyTable into qvd path..
else // we don't do anything new, we just import the data in the qvd
drop table MyTable;
load * from QVD;
exit script
Hi Omar,
Can you share me your personal email id.
I would like to share my QVF file
Thanks,
Siva
Hi Omar,
Here, I am attached my QVF file. Could you please look in it and let me know if any suggestions required?
Thanks,
Siva