Relation tables and bring date

[pgalvezt]

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;

Is like a vlookup in excel.

See attach Please.

Thanks

[CELAMBARASAN]

I think Homologo_Btcc11 is in text format

Homologo_Btcc11 is in Number format so may be format mismatch

use Num(Trim(Homologo_Btcc11)) AS Homologo_Btcc11 for tis and chk

[pgalvezt]

Its not working.

What I want is ask in Btc11 767462700 go looking into Bsc01 if it found bring me the FechaProtesto.

See the jpgs please.

Thanks

[CELAMBARASAN]

As seen Btc11 has multiple entries with same number

the same Bsc01 has multiple entries then applymap won't work correctly.

[pgalvezt]

Thanks for your reply what should I do with this problem?

[CELAMBARASAN]

small question: If you u have a number in Bsc01 multiple times with different dates which date you need to apply for the same number in the Btc11 field?

[pgalvezt]

The question is if a have a number in Btcc11 which date I need to apply for the same number in the Bsc01.

R: first if you see the attached jpgs. You could see 767462700 (in btcc11) this number is into bsc01 too so if Btcc11 (76746700) looking into Bsc01 found the same number and bring the fechaprotesto.

Is like to do clic in both fields (see the attached jpgs)

Thank you

[pgalvezt]

Hello, I prepared a details with What I want.

From two tables Btcc11 and Bsc01 I Exported it to excel and in excel I did this :

=BUSCARV(M2;'C:\Documents and Settings\pablo.galvez\Escritorio\[Export Bsc01.xls]Sheet1'!$D$1:$D$65536;1;FALSO) So Excel bring me the values associated from Bsc01. After that I didi a filter where all #N/A disappear. Its possible to do this in QlikView? For better comprehenssion I attached Details Files.