Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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;
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