LOAD SCRIPT

[Carlaf_93]

Good morning,

i need help to load some data.

In a nutshell, i need to load two specific table of data like those:

[Table_1 ]:

LOAD 

YEAR,

FIELD_A,

FIELD_B

FROM [A];

[Table_2]:

LOAD 

FIELD_A,

FIELD_c,

FIELD_D

FROM [B];

Now i would like to create a unike table that take all this field and eliminate those two tables.

i would like to have:

[total]:

YEAR,

FIELD_A,

FIEALD_B,

FIELD_c,

FIELD_D;

P.S. the field FIEALD_A is the link between them.

[Kushal_Chawda · Accepted solution]

may be joining two table

[Table_1 ]:

LOAD 

YEAR,

FIELD_A,

FIELD_B

FROM [A];

left join(Table_1)

LOAD 

FIELD_A,

FIELD_c,

FIELD_D

FROM [B];