Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hola a todos, estoy recibiendo un error en el Sense que no sé de dónde puede venir, es al hacer un LOAD y después su SELECT correspondiente, pues bien si hago el select sin ningún where funciona correctamente y lee la tabla, ahora en cuánto pongo el where con un campo siempre me devuelve Field not found señalando no al campo que tengo en el where sino al primer campo tras el select "Field 'key_venta' not found. Evidentemente los campos existen y están en la tabla, cómo digo, si quito el where la lee correctamente y no dá error. Paso a poneros el código por si alguien me pudiera orientar. Gracias y saludos.
//compruebo si existe el fichero de ventas, si no existe hago carga total, si existe parcial
LET vSize = FileSize('lib://qvd_ventas_qlik (hiperusera_upcinf060)/f_venta.qvd');
If Not IsNull(vSize) then
//carga parcial
//calculamos la ultima fecha de carga del qvd
/*
CargaQvd:
LOAD f_vent.key_venta,
f_vent.data_change_dtw
FROM [lib://qvd_ventas_qlik (hiperusera_upcinf060)/f_venta.qvd](qvd);
UltimaCarga:
LOAD MAX([f_vent.data_change_dtw]) as maximaFechaCargada Resident CargaQvd;
//lo dejo en variable
LET vUltimaCarga = DATE((Peek('maximaFechaCargada',0,'UltimaCarga')));
DROP TABLE CargaQvd;
//DROP TABLE UltimaCarga;
*/
//cargamos modificados
LOAD [key_venta] as [f_vent.key_venta],
[fecha] as [f_vent.fecha],
[tpv] as [f_vent.tpv],
[ticket] as [f_vent.ticket],
[ticket_relacionado] as [f_vent.ticket_relacionado],
[puntos_ticket] as [f_vent.puntos_ticket],
[puntos_articulo] as [f_vent.puntos_articulo],
[puntos_nivel] as [f_vent.puntos_nivel],
[cantidad] as [f_vent.cantidad],
[iva] as [f_vent.iva],
[recargo_equiv] as [f_vent.recargo_equiv],
[peso_gr] as [f_vent.peso_gr],
[en_oferta] as [f_vent.en_oferta],
[tipo_oferta_simple] as [f_vent.tipo_oferta_simple],
[clase_oferta] as [f_vent.clase_oferta],
[lote] as [f_vent.lote],
[cobrado] as [f_vent.cobrado],
[pc_compra] as [f_vent.pc_compra],
[imp_pc_compra] as [f_vent.imp_pc_compra],
[pv_tpv] as [f_vent.pv_tpv],
[pv_tpv_oferta] as [f_vent.pv_tpv_oferta],
[pv_tpv_margen] as [f_vent.pv_tpv_margen],
[imp_pv_tpv] as [f_vent.imp_pv_tpv],
[imp_pv_tpv_oferta] as [f_vent.imp_pv_tpv_oferta],
[imp_pv_tpv_margen] as [f_vent.imp_pv_tpv_margen],
[pv_tpv_sin_imp] as [f_vent.pv_tpv_sin_imp],
[pv_tpv_oferta_sin_imp] as [f_vent.pv_tpv_oferta_sin_imp],
[pv_tpv_margen_sin_imp] as [f_vent.pv_tpv_margen_sin_imp],
[imp_pv_tpv_sin_imp] as [f_vent.imp_pv_tpv_sin_imp],
[imp_pv_tpv_oferta_sin_imp] as [f_vent.imp_pv_tpv_oferta_sin_imp],
[imp_pv_tpv_margen_sin_imp] as [f_vent.imp_pv_tpv_margen_sin_imp],
[data_change_dtw] as [f_vent.data_change_dtw],
[id_md_organizacion] as [md_org.id_md_organizacion],
[id_md_articulo] as [md_art.id_md_articulo],
[id_md_nivel] as [md_niv.id_md_nivel],
[id_md_proveedor] as [md_pro.id_md_proveedor],
[id_md_comprador] as [md_comp.id_md_comprador],
[id_md_vendedor] as [md_ven.id_md_vendedor],
[id_md_cliente] as [md_cli.id_md_cliente],
[id_md_operador] as [md_ope.id_md_operador],
[id_md_supervisor] as [md_sup.id_md_supervisor],
[key_organizacion] as [d_org.key_organizacion],
[key_articulo] as [d_art.key_articulo],
[key_nivel] as [d_niv.key_nivel],
[id_md_nivel_agrupado] as [md_niv_agr.id_md_nivel_agrupado],
[key_proveedor] as [d_pro.key_proveedor],
[key_comprador] as [d_comp.key_comprador],
[key_vendedor] as [d_ven.key_vendedor],
[key_cliente] as [d_cli.key_cliente],
[key_operador] as [d_ope.key_operador],
[key_supervisor] as [d_sup.key_supervisor],
[key_fecha] as [d_fec.key_fecha],
[key_hora] as [d_hora.key_hora],
[tipo_oferta_compleja] as [f_vent.tipo_oferta_compleja],
[recargo] as [f_vent.recargo],
[imp_pc_compra_sin_rec] as [f_vent.imp_pc_compra_sin_rec],
[key_tipo_centro] as [d_tce.key_tipo_centro],
[key_tipo_cliente] as [d_tcl.key_tipo_cliente],
[id_md_tipo_centro] as [md_tpc.id_md_tipo_centro],
[id_md_tipo_cliente] as [md_tcl.id_md_tipo_cliente];
[f_venta]:
SELECT "key_venta",
"fecha",
"tpv",
"ticket",
"ticket_relacionado",
"puntos_ticket",
"puntos_articulo",
"puntos_nivel",
"cantidad",
"iva",
"recargo_equiv",
"peso_gr",
"en_oferta",
"tipo_oferta_simple",
"clase_oferta",
"lote",
"cobrado",
"pc_compra",
"imp_pc_compra",
"pv_tpv",
"pv_tpv_oferta",
"pv_tpv_margen",
"imp_pv_tpv",
"imp_pv_tpv_oferta",
"imp_pv_tpv_margen",
"pv_tpv_sin_imp",
"pv_tpv_oferta_sin_imp",
"pv_tpv_margen_sin_imp",
"imp_pv_tpv_sin_imp",
"imp_pv_tpv_oferta_sin_imp",
"imp_pv_tpv_margen_sin_imp",
"data_change_dtw",
"id_md_organizacion",
"id_md_articulo",
"id_md_nivel",
"id_md_proveedor",
"id_md_comprador",
"id_md_vendedor",
"id_md_cliente",
"id_md_operador",
"id_md_supervisor",
"key_organizacion",
"key_articulo",
"key_nivel",
"id_md_nivel_agrupado",
"key_proveedor",
"key_comprador",
"key_vendedor",
"key_cliente",
"key_operador",
"key_supervisor",
"key_fecha",
"key_hora",
"tipo_oferta_compleja",
"recargo",
"imp_pc_compra_sin_rec",
"key_tipo_centro",
"key_tipo_cliente",
"id_md_tipo_centro",
"id_md_tipo_cliente"
FROM "public"."f_venta" WHERE data_change_dtw > '23/07/2018';
Hola..
probaste utilizando una variable y colocando el formato de fecha:
Select....
where data_change_dtw <= to_date('$(VFechaCorte)', 'dd/mm/yyyy');