Join / Concatenate / Keep ?

[tan_chungkam]

Hi all,

I would like to combine 2 tables as below:

Table1:

Name         Height          Blood

1. A              150                 A

2. B              160                 O

3. C              170                 AB

Table2:

Name          Weight

1. A               45

2. B               50

3. C               55

4. D               60

My Outcome should be as below:

Finaltable:

Name          Height           Weight          Blood

1. A               150                  45                   A

2. B               155                  50                   O

3. C               160                  55                   AB

4. D                -                       60                   -

I have tried using Left Join (table1). However it doesn't take  person D into table 1.

I have also tried Concatenate (table1). However the data will be duplicated.

As I need to do a calculation in scripting hence i would need to combine 2 tables into 1.

Is there any function to do that?

Thanks in advance.

[Anonymous · Accepted solution]

Kindly use Outer join.

[MindaugasBacius]

Try this script:

tmp:
LOAD * INLINE [
Name, Height, Blood
A, 150, A
B, 160, O
C, 170, AB];

Right Join(tmp)
LOAD * INLINE [
Name, Weight
A, 45
B, 50
C, 55
D, 60];

You will end up with one table and this result:

Also see the attachment.

[tan_chungkam]

It works. Thanks for the help