Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Add or Update Data in QVD through QMC

I created this load to bring in data, I now need to push this to QMC and set a task but i dont want this to run from start date everytime. I only want it to run and add or update missing data in the QVD that already exist.

How can I do that?

Any help will be appreciated.

"LET vStartDate = MakeDate(2015,7,30);      //(2015,7,30);

LET vEndDate = (TODAY()-1);

Partner:

LOAD DISTINCT

    DISTRIBUTOR_ID as TIPS_DISTRIBUTOR

FROM [lib://QVD_Transform/T_Partner.qvd](qvd)

WHERE "Software Provider" = 'TIPSNETWORK'

;

FOR vDayNo = vStartDate to vEndDate;

LET vDate = Date(vDayNo, 'YYYY_MM_DD');

 

Temp_SplitterTransaction:

    Load *

    From [lib://QVD_Extract/DailySplitterExtract/E_SplitterTransaction_$(vDate).qvd](qvd)

    WHERE exists (  TIPS_DISTRIBUTOR, ORIGINATING_DISTRIBUTOR_ID) and NOT Exists (TRANSACTION_DATE, TRANSACTION_DATE) ;

    //WHERE exists (TIPS_DISTRIBUTOR, ORIGINATING_DISTRIBUTOR_ID);

T_TIPS:

    LOAD *

     RESIDENT Temp_SplitterTransaction

    WHERE MATCH (TRANSACTION_CODE, 0, 35);

     

If Not IsNull(QvdCreateTime('lib://QVD_Transform/T_Tips.qvd')) then

    CONCATENATE(T_TIPS)

        LOAD  *

        FROM [lib://QVD_Transform/T_Tips.qvd](qvd) WHERE NOT EXISTS([Transaction Date Check], [Transaction Date]);

Endif

DROP FIELD [Transaction Date Check];

STORE T_TIPS INTO [lib://QVD_Transform/T_Tips.qvd];

              

       

DROP TABLE Temp_SplitterTransaction;

DROP TABLE T_TIPS;

NEXT vDayNo

EXIT SCRIPT;"

1 Reply
mahesh3k
Contributor

Re: Add or Update Data in QVD through QMC

I have not gone through your script ,but Incremental Load should work for you, Check out below Documents

Incremental Load in Qlikview - Sources

Community Browser