problem in script when converting QVX to Qvd

[Anonymous]

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

[Colin-Albert]

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

[stigchel]

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)

[jonas_rezende]

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;