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
(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
