2 Replies Latest reply: Jul 1, 2014 11:09 PM by PAUL YEO RSS

    How to add one more QVD table into my QV file ?

    PAUL YEO

      Hi All

       

      I have below script which is working fine for very long , it work because all QVD table are having same data structure . today i try to add in one more different data structure table , which appear on the last 2 line of the script . basically the last line of the QVD table is exchange rate table . can some one tell me how can i make it working ? i have try noConcatenate also not work. once it work i can bring in many such table.

       

      PRICE:

       

      load * from $(vQVDPath)BECKHOFF.qvd (qvd);

       

       

      Concatenate

       

       

       

       

      load * from $(vQVDPath)HAKKO.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)GE.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)HMS.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)KEB.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)REDLION9.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)SCM.qvd (qvd);

       

       

      Concatenate

       

       

      load * from $(vQVDPath)KINCO.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)LOCAL_TKL.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)LOCAL_TDS.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)LOCAL_TDST.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)BECKHOFF_TKL.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)Phoenix.qvd (qvd);

       

       

      Concatenate

      load * from $(vQVDPath)IBH.qvd (qvd);

       

       

      //Concatenate

      //load * from $(vQVDPath)IBH_RATE_RATE.qvd (qvd);