topic Connect 2 Fields? in QlikView

Connect 2 Fields?

Wed, 29 Sep 2010 13:24:47 GMT

Hi Dears;

I would like to as follows :

Table1:
a,
b,
c,
d;

Table2:
i as a,
x,
y,
z,
if(b=x,y);

May i use resident and how? Or How can i do it?

Thanks
Best Regards...

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 13:31:25 GMT

Hello,

Try the following:

Table1:a,b,c,d;Table2:i as a,x,y,z,WHERE EXISTS(b, x) OR EXISTS(b, y);

Hope that helps.

Wed, 29 Sep 2010 13:48:23 GMT

Hi;

I have 2 different tables from same database.

Is it true for this ?

Thans in advance...

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 14:10:31 GMT

Hello,

Yes, since it works with already loaded data (first pull frorm the data source, then loads into memory only those who match).

Regards.