Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Left Join not working

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?

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

2 Replies
sunny_talwar

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;

arvind_patil
Partner - Specialist III
Partner - Specialist III

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