Left Join not working

[Anonymous]

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?

[sunny_talwar · Accepted solution]

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]

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