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
