3 Replies Latest reply: May 26, 2015 9:49 AM by Jonas Melo RSS

    problem in script when converting QVX to Qvd

    kumar avisakula

      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