Discussion Board for collaboration on QlikView Scripting.
I need to concatenate a QVD to other QVD based on the month end of "Month_date" column
Date(Today(),'DD/MM/YYYY') as Month_date
From Dummy.xlsx(ooxml, embedded labels);
STORE CurrentData into CurrentData.qvd(qvd);
LET vMonth = Date(Today(),'DD/MM/YYYY');
LET vMonthend= Date(MonthEnd(Today()),'DD/MM/YYYY');
IF '$(vMonth)' = '$(vMonthend)' then
LOAD * from HistoricalData.qvd(qvd);
DROP Table CurrentData;
But the above Script marked in Red is not working.
Anyone could you help me on this...
Go to Solution.
I am sure you can not see the table CurrentData at all. Am I right?
If yes then i want to point out something in your script.
If you look into your script, after concatenating the CurrentData in Historical data, you will need to store the data in to historical again.
Meaning the data got concatenated in qpplication but not stored in qvd.
So your script should be like this.
Load * ,' ' as junk resident CurrentData;
Store CurrentData into HistoricalData.Qvd;
Hope this is clear
It may not be working cause you may not have HistoricalData.qvd
What error it is giving?
HistoricalData.qvd already existed...
condition is working fine but it is not concatenating the CurrentData table to HistoricalData QVD.
drop field junk;