Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing problem with the script when converting from QVX to QVD. The script i have written is
Let Vqvxpath = 'D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Prj\Site_Catalyst\';
Let Vqvdpath = 'D:\QlikView\SourceDocuments\QVD\Mktg_Funnel_Prj\Site_Catalyst\LoppQVD\';
Inserts:
LOAD *
FROM
$(Vqvxpath)dim_lead_inserts.qvx(qvx);
date_dim_lead:
LOAD Max(lead_record_updated_datetime) as dim_lead_Maxdate
Resident Inserts;
LET VDate_dim_lead = Peek('dim_lead_Maxdate',0,'date_dim_lead');
DROP Table date_dim_lead;
STORE Inserts into $(Vqvdpath)dim_lead.QVD(qvd);
DROP Table Inserts;
Updates:
LOAD *
FROM
$(Vqvxpath)dim_lead_updates.qvx(qvx)
Where (lead_record_updated_datetime >$(VDate_dim_lead));
Concatenate
LOAD *
FROM
$(Vqvdpath)dim_lead.qvd(qvd)
Where not Exists(lead_key);
STORE Updates into $(Vqvdpath)dim_lead.QVD(qvd);
DROP Table Updates;
I am getting below error like this. Pls help me on this one
Thanks in advance
You need to have a space between the file extension and the (qvd) part of the expression.
Try changing your script to
Concatenate
LOAD *
FROM
$(Vqvdpath)dim_lead.qvd (qvd)
Where not Exists(lead_key);
STORE Updates into $(Vqvdpath)dim_lead.QVD (qvd);
Your variable VDate_dim_lead is empty, see the error message where(lead_record_updated_datetime >)
You probably need to format the contents of lead_record_updated_datetime as date in this statement
LOAD Max(lead_record_updated_datetime)
Hi, Kummar Reddy.
First thing going to do is, check the quantity of row in table date_dim_label, certainly is zero.
After, the cause in table Inserts.
Can help it, insert a counter after comma(;). E.g.:
LET rowDate_dim_label = NoOfRows('date_dim_lead');
trace 'Row in table date_dim_label' & $(rowDate_dim_label);
P.S.: Start file log in qvw;