topic Re: problem in script when converting QVX to Qvd in QlikView

problem in script when converting QVX to Qvd

Anonymous — Tue, 26 May 2015 09:38:38 GMT

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

Re: problem in script when converting QVX to Qvd

Colin-Albert — Tue, 26 May 2015 09:53:19 GMT

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);

Re: problem in script when converting QVX to Qvd

stigchel — Tue, 26 May 2015 10:00:28 GMT

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)

Re: problem in script when converting QVX to Qvd

jonas_rezende — Tue, 26 May 2015 13:49:11 GMT

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;