topic Re: left join one record in QlikView

left join one record

Fri, 26 Dec 2014 19:56:02 GMT

hi,

i have this

Table1

Table2

ID A

1 x

1 y

2 x

3 z

i need to left join a table1 with table2 but i only one description

how can i do this?

Re: left join one record

MK_QSL — Fri, 26 Dec 2014 20:06:35 GMT

Not able to understand your requirements !

Can you provide us the final result you are looking for?

Thanks

====

use below script

T1:

Load * Inline

[

];

T2:

Load *, AutoNumber(ID & A) as Sequence Inline

[

ID, A

1, x

1, y

2, x

3, z

];

Left Join (T2) Load ID, Min(Sequence) as MinKey Resident T2 Group By ID;

Inner Join (T1)

Load * Resident T2 Where Sequence = MinKey;

Drop Table T2;

Drop Fields Sequence, MinKey;

Re: left join one record

Anonymous — Fri, 26 Dec 2014 20:09:21 GMT

Hi,

Please Try:

Table1:
load * inline
[
ID

1

2

3

4
];

Table2:
Left Join(Table1)
load * inline
[

ID,A

1,x

1,y

2,x

3,z
];

Re: left join one record

Fri, 26 Dec 2014 20:10:08 GMT

result Table

ID A

1 x

2 x

3 z

Re: left join one record

MK_QSL — Fri, 26 Dec 2014 20:13:53 GMT

check my previous reply...

Re: left join one record

Sat, 27 Dec 2014 14:57:10 GMT

Actually I get your result by just loading the second bulk of items by using not exists (ID)

LOAD * INLINE [

ID, A,

1,X

1,Y

2,X

3,Z]

Where not Exists(ID) ;

Re: left join one record

Sat, 27 Dec 2014 15:00:46 GMT

But in the case You still need to do a left Join, here is the order to achieve the same result.

Table1:

LOAD * INLINE [

ID, A,

1,X

1,Y

2,X

3,Z]

Where not Exists(ID) ;

left join

LOAD * INLINE [

ID,

4 ];