Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sagarkharpude
Contributor III

SAP Incremental Load

Hi All,

Can someone provide me the incremental script for VBAP sap table.

Thanks

Sagar Kharpude

3 Replies

Re: SAP Incremental Load

amit_saini
Honored Contributor III

Re: SAP Incremental Load

Sagar,

Try something below:

Let suppose table name is "BSIS"

----------------------------------------------------------------------

Let vStart = now();

Let vReloadStart = now();

//############## ##############

set vTab = 'BSIS';

$(vTab):

select * from $(vTab)

;

LET vMDTB_LOAD_DURATION = Interval(now() - vStart) ;

LET vStart = now();

//############## ##############

store $(vTab) into $(vTab).qvd;

LET vMDTB_Size = num(filesize('$(vQVD)\BSIS.qvd')/1024,'00.0') & ' KB';

LET vMDTB_Records = QvdNoOfRecords ('$(vQVD)\BSIS.qvd');

//############################

drop table $(vTab);

Thanks,
AS

sagarkharpude
Contributor III

Re: SAP Incremental Load

Hi Aninash,

I checked this but not working as we expect

Thanks

Community Browser