topic Left Join not working in QlikView

Left Join not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

PK:

LOAD * INLINE [

Key, Name, Grade

1234a, a, 1

1235b, b, 2

1236c, c, 3

];

VK:

LOAD * INLINE [

Key, Colour, Smell

1234a, red, nice

1235z, blue, great

1236c, yellow, vnice

];

JoinTable:

load * resident PK;

left Join

load * resident VK;

drop Tables VK,PK;

Any idea why it is not working....I would expect to join on Key so 2 lines one for 1234a and one for 1236c?

Re: Left Join not working

sunny_talwar — Wed, 02 May 2018 12:41:24 GMT

Try this

PK:

LOAD * INLINE [

Key, Name, Grade

1234a, a, 1

1235b, b, 2

1236c, c, 3

];

VK:

LOAD * INLINE [

Key, Colour, Smell

1234a, red, nice

1235z, blue, great

1236c, yellow, vnice

];

JoinTable:

NoConcatenate

load * resident PK;

left Join

load * resident VK;

drop Tables VK,PK;

Re: Left Join not working

arvind_patil — Wed, 02 May 2018 12:42:19 GMT

Hi Raphael,

Please use below code:

PK:

LOAD * INLINE [

Key, Name, Grade

1234a, a, 1

1235b, b, 2

1236c, c, 3

];

VK:

LOAD * INLINE [

Key, Colour, Smell

1234a, red, nice

1235z, blue, great

1236c, yellow, vnice

];

Noconcatenate

JoinTable:

load * resident PK;

left Join

load * resident VK;

drop Tables VK,PK;

Thanks,

Arvind Patil