Qvd file not able create in incremental load

[Anonymous]

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

[Anonymous]

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;