Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I trying to eliminate reference circular.
MapBttcc11_Bin:
Mapping
LOAD Distinct Clasificacion_Bin,CC_Cli Resident ComercioCartera;
Castigos:
//Concatenate
LOAD
ApplyMap('MapBttcc11_Bin',Clasificacion_Bin) as CC_Cli,
CC_CLI,
CC_TAR,
CC_RUT,
CC_DV,
NOMBRE,
CM_PRO,
CD_PRO,
CM2_ABOK,
DEUDA as Deuda_Castigo,
CC_CARTERA,
CASTIGA,
MonthName(Date(FECHA -1,'MMM-YY')) as Periodo,
INGRESO
FROM
(ooxml, embedded labels, table is Castigos);
Error: QlikView not find the field Clasificacion_Bin...
Thanks
Qué es Clasificacion_Bin?
Creo que deberías quitar ese campo de Cartera o de ComercioCa...
Fijate que están todas las tablas linkeadas. De acuerdo con la naturaleza de ese campo y dónde querés que se informe, debería estar en un solo lugar.
Si, por alguna razón, la función de ese campo es distinta en cada tabla, cambiá el nombre del campo en una de las tablas y listo!
Hi
is Clasificacion_Bin field in Castigos_2012.xlsx? If not, this error occur
Hi,
does Clasificacion_Bin field exist in Castigos_2012.xlsx?
Nop, I try to join ccli (Cod Customer) I have a Table that contain CC_Cli,
ComercioCartera:
LOAD Clasificacion_Bin,
CC_Cli,
Comercio
FROM
(qvd);
Castigos:
//Concatenate
LOAD
//ApplyMap('MapBttcc11_Bin',Clasificacion_Bin) as CC_Cli,
CC_CLI,
CC_TAR,
CC_RUT,
CC_DV,
NOMBRE,
CM_PRO,
CD_PRO,
CM2_ABOK,
DEUDA as Deuda_Castigo,
CC_CARTERA,
CASTIGA,
MonthName(Date(FECHA -1,'MMM-YY')) as Periodo,
INGRESO
FROM
(ooxml, embedded labels, table is Castigos);
I have to join CC_CLI, with CC_Cli, but when I renamed this field like CC_Cli, reference circular appears because Periodo are in another tables
Hi
In ComercioTarjetas.qvd, CC_Cli as CC_CLI , by this, you can avoid the circular reference, i think..
I already tried that but How can I avoid this.
HI
You can use noconcatenate concept to avoid the circular reference.
Hi, I put this but doesn't work
Castigos:
NoConcatenate
LOAD
//ApplyMap('MapBttcc11_Bin',Clasificacion_Bin) as CC_Cli,
CC_CLI,
CC_TAR,
CC_RUT,
CC_DV,
NOMBRE,
CM_PRO,
CD_PRO,
CM2_ABOK,
DEUDA as Deuda_Castigo,
CC_CARTERA,
CASTIGA,
MonthName(Date(FECHA -1,'MMM-YY')) as Periodo,
INGRESO
FROM
(ooxml, embedded labels, table is Castigos);
Any help?
I tried with mapping function but I think I need at least one same field in another table.
Thanks
Hi
When you use mapping , that field want to be that table..Use can use Periodo as PeriodoCastigos.. By this, you can avoid circular reference.