Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I reckon that will :
I suspect what you need to do is :
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;