topic Re: left join with 2 resident tables in QlikView

left join with 2 resident tables

Fri, 06 Dec 2013 18:16:24 GMT

Hi everybody,

i need to create a resident table T3 from 2 resident tables T1 and T2:

T1:

LOAD FIELD1 resident t0a;

T2:

LOAD FIELD2 resident t0b;

with a left join because i want all the values of FIELD1 associated with the FIELD2:

so T3 msut have 3 fields and must be similar to follow :

FIELD1 FIELD2 FIELD3

A 0

B B 1

C C 1

Field3 must satisfy the condition ----> IF( FIELD1=FIELD2,1,0)

but how can i build the correct script?

I kindly ask you a help!!

Thanks in advance

bye

fred_s — Fri, 06 Dec 2013 19:53:37 GMT

Hi,

I'd love to help you but I don't understand your question.
Could you attach your file?

Fri, 06 Dec 2013 20:07:26 GMT

LEFT JOIN means that only the fields of T1 will be kept:

LEFT JOIN (T1)

Field2 as Field1,

Field2

Resident T2

T3:

Load Field1, Field2,

if(Field1=Field2, 1, 0) as Flag

Resident T1

Fabrice