Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qvd file not able create in incremental load

Hi,

I am facing one issue. I have fact table file data and it is overriding daily. If I do normal script, QVD file will be override when fact table data is getting override on daily basis. So to overcome that, I have written code like this

If FileSize('$(Vqvdpath)test.qvd') > 0 then

test1:

    LOAD * FROM fact table;

Store table  into test.qvd(qvd);

  

DROP Table test1;

ENDIF.


But it is not creating any QVD file. please help me where it is going wrong.

Regards,

Kumar Reddy

20 Replies
Anonymous
Not applicable
Author

I reckon that will :

  • Load data from the xlsx into resident table test1
  • Store this data from the xlsx into the qvd file
  • Check if that qvd exists:  If the STORE before worked then it will by definition exist
  • Add the data just stored into the qvd file onto the end of resident table test1, duplicating the data that was already in there
  • Drop the resident table test1

I suspect what you need to do is :

  • Load data from the xlsx into resident table test1
  • If qvd file exists
    • Add data from qvd onto data in resident table test1
    • End of if
  • Store this data now in resident table test1 into qvd
    • Thus overwriting old data in qvd if it existed, otherwise create new qvd file
  • Drop resident table test1

Maybe using script like this :

test1:

LOAD * FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

IF     FileSize('C:\Users\Ramprasad\Desktop\Marketing funnel QVW/test.qvd') > 0 then

Concatenate(test1)

LOAD * From

C:\Users\Ramprasad\Desktop\Marketing funnel QVW\test.QVD(qvd);


ENDIF


STORE test1 into C:\Users\Ramprasad\Desktop\Marketing funnel QVW\test.QVD(qvd);


DROP Table test1;