topic Using Exists between two resident Table's in QlikView

Using Exists between two resident Table's

amars — Tue, 08 Jun 2010 08:19:16 GMT

hi all,

I want to use Exists between two resident table. Actually I have two tables with same fields in it.

Table1, Table2 & I want to add the rows of Table2 to Table1 based on a single field value present in Table 1. I wish to use a statement like this Join (Table1) Load Field...... from Table2 Where exists(Field1, Load Field1 from Table1);

I really don't know how to do that. Could anyone tell me that. Thanks in advance

With Regards

Amar

Using Exists between two resident Table's

sparur — Tue, 08 Jun 2010 10:48:11 GMT

Hello

CONCATENATE(Table1)

Load

Field1,

Field2

....

RESIDENT Table2

WHERE Exists(Field1, Field1);

where field "field1" exists on both tables.

but if you want join some fields from Table2 into Table1 you no need to use Exists function.

LEFT JOIN(Table1)

Load

Field1,

Field2

....

RESIDENT Table2;

after this field2 joined into Table1 by field "Field1"