No Field

[pgalvezt]

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

[MayilVahanan]

Hi

is Clasificacion_Bin field in Castigos_2012.xlsx? If not, this error occur

[bgerchikov]

Hi,

does Clasificacion_Bin field exist in Castigos_2012.xlsx?

[pgalvezt]

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

[MayilVahanan]

Hi

     In ComercioTarjetas.qvd, CC_Cli as CC_CLI , by this, you can avoid the circular reference, i think..

[pgalvezt]

I already tried that but How can I avoid this.

[MayilVahanan]

HI

     You can use noconcatenate concept to avoid the circular reference.

[pgalvezt]

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);

[pgalvezt]

Any help?

I tried with mapping function but I think I need at least one same field in another table.

Thanks

[MayilVahanan]

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.