topic Re: Bring value from other table in QlikView

Bring value from other table

pgalvezt — Tue, 17 Jul 2012 18:28:01 GMT

Hello, I have a Sentence:

if(num(Field1) = 1, I want to join one Field from table 1 and one Field from Table 2. I tried

BloqueoCartera:
Mapping Load
Homologo_Bsc01,
Tipo_Cartera_Bsc01
Resident BSC01;

Join(BTCC11)
Load Homologo_Btcc11,
if(num(`cod_bloq`) = 8, ApplyMap('BloqueoCartera',Homologo_Btcc11,Null())) as OtraCartera.

Nothing Happened.

Thank You

MayilVahanan — Tue, 17 Jul 2012 18:48:24 GMT

Hi,

Try like this,

Check the cod_bloq contains 8,

Join(BTCC11)

Load Homologo_Btcc11,

if(num(cod_bloq) = 8, ApplyMap('BloqueoCartera',Homologo_Btcc11,Null()),'Others') as OtraCartera

from ..

Donot use 'cod_bloq' , its take as string ..

Check Others value appear in OtraCartera..And then See the unMapped values based on it..By this, may be you can find Solution..

Hope it helps