Joining Tables

[ValeriaBonini]

Hi, in my load script I have 2 tables:

Table1:

Name     Code

A               1
B               2

C               3

Table2:

Name     Cod     Address

A               1             xxx
bb             2            yyy

C               3              zzz

the load script is like this

Table1: Load Name, Code from  ....;

left join(Table1😞 Load Name, Cod as Code, Address   from  ...;

but I still have a table where for the Code 2 I have no Address... how can I resolve this?

[Mark_Little]

Hi, 

or join looks like

left Join (Table1)

Load ...

then i would expect it to work. If you still aren't getting the expected results then it is most likely down to the format of the field values try something like

Trim() around Name and Code, then maybe a format function like NUM() or Text to ensure they are formatted the same

[BrunPierre]

@ValeriaBonini It happens because the join is on both the Code and Name columns, and there's no matching value ( B and bb) in the Name field for the second record.

You could comment out the Name column in the joining table.

Table1:
LOAD Name,
Code

FROM ABC;

Left Join
Table1:
LOAD //Name,
Code,
Address

FROM XYZ;