Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Vlookup Problem

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

Labels (1)
2 Replies
pgalvezt
Specialist
Specialist
Author

For better comprehenssion.

pgalvezt
Specialist
Specialist
Author

Any Help?

Thanks