Vlookup Problem

pgalvezt — Thu, 12 Jul 2012 17:45:44 GMT

Hello! I trying to extract data from table 1(Btcc11) to table 2(Bsc01) in excel I did vlookup and the formula bring me 5 values but QlikView bring everything What doing I Wrong?

BTCC11:

LOAD

Homologo_Btcc11,

Deuda_Total,

dvr,

Estado,

Num_Tarjeta,

rut

FROM

(qvd);

BSC01:

LOAD

Rut_Bsc01,

Fecha_Protesto,

Monto_Protesto,

TarjetaBsc01,

Homologo_Bsc01

FROM

(qvd);

MapFecha_Protesto:
Mapping Load Homologo_Bsc01,Fecha_Protesto Resident BSC01;

Join(BTCC11)
Load Homologo_Btcc11,ApplyMap('MapFecha_Protesto',Homologo_Btcc11,Null()) as FechaProtesto Resident BTCC11;

See attach Please.

Thanks

Re: Vlookup Problem

pgalvezt — Thu, 12 Jul 2012 18:47:36 GMT

For better comprehenssion.

Re: Vlookup Problem

pgalvezt — Thu, 12 Jul 2012 19:48:50 GMT

Any Help?

Thanks

topic Re: Vlookup Problem in QlikView

Vlookup Problem

Re: Vlookup Problem

Re: Vlookup Problem