2 Replies Latest reply: Aug 6, 2013 9:58 AM by Federico Toso RSS

    Load Script problem

    Federico Toso

      Hi everyone,

      Im using Qlickview 11 Personal free edition, but when i run the script it takes 3 or 4 hours to complete loading the script.... do you know what is wrong??

      Also attached a image of the loading form.

       

       

      This is the script:

       

      SET ThousandSep='.';

      SET DecimalSep=',';

      SET MoneyThousandSep='.';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='$ #.##0,00;$-#.##0,00';

      SET TimeFormat='hh:mm:ss TT';

      SET DateFormat='DD/MM/YYYY';

      SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

      SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

      SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

       

       

      LOAD Periodo,

           Year,

           Quarter,

           Month,

           Cod_Dia,

           Clasificacion,

           Desc_Stock_Number,

           Factor_Conver,

           Cod_Modelo,

           Cod_GSC,

           Cod_Stock_Number,

           Cod_Cliente,

           Desc_Cliente,

           Cod_Vendedor,

           Desc_Vendedor,

           Cod_Dpto_Vta,

           Desc_Dpto_Vta,

           Cod_Origen,

           Desc_Territ_Vta,

           Desc_Sub_BU,

           Desc_BU,

           Desc_BU2,

           Desc_Gerencia,

           Cod_Planta,

           Cod_Commodity,

           Desc_Commodity,

           Cod_Linea_Vta,

           Unid_Medida,

           Cant_Vend,

           Vta_Neta_P,

           CGS_P,

           Vta_Neta_D,

           CGS_D,

           tc,

           %GM,

           PVC_CLASS,

           [Vta Neta DC],

           [CGS DC]

      FROM

      [C:\Users\2012-mes ant.xlsx]

      (ooxml, embedded labels);

       

       

      LOAD Gte_Vendedor,

           Desc_BU,

           Desc_Vendedor,

           Couta,

           Periodo

      FROM

      C:\Users\CuotasM3.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

       

      LOAD Cod_Dia,

           Periodo,

           Year,

           Quarter,

           Month,

           Clasificacion,

           Desc_Stock_Number,

           Cod_Stock_Number,

           Cod_Modelo,

           Cod_Dpto_Vta,

           Desc_Dpto_Vta,

           Cod_Cliente,

           Desc_Cliente,

           Cod_Vendedor,

           Desc_Vendedor,

           Cod_Origen,

           Desc_Territ_Vta,

           Desc_Sub_BU,

           Desc_BU,

           Desc_BU2,

           Desc_Gerencia,

           Cod_Planta,

           Cod_Commodity,

           Desc_Commodity,

           Cod_Linea_Vta,

           Unid_Medida,

           %GM,

           Cant_Vend,

           Vta_Neta_P,

           CGS_P,

           [Vta Neta DC],

           Vta_Neta_D,

           PVC_CLASS,

           [CGS DC],

           CGS_D

      FROM

      C:\Users\mesactual.xlsx

      (ooxml, embedded labels);

       

       

      Thanks!!

       

       

       

      en → es
      las etiquetas
      sustantivo: etiqueta, rótulo, marbete, calificación, clasificación, designación, letrero, marchamo, descripción, tejuelo