How to join multiple tables?

[Nolgath]

I have this script: 

I have same field names and I get AT.make and BE.make, but I just need "make" to be global, I think I can do this with Dealer as the primary key. I've tried "Concat(table_1, '-', dealer) as PrimaryKey2" but this just gives me an error that table_1 does not exist.

table_1:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is AT);

Table2:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is BE);

Any tips?

[Lokesh_5045]

Is table1 is subset of Table2?

[vikasmahajan · Accepted solution]

Hi,

Use concatenate 

table_1:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is AT);

Concatenate(table_1)
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is BE);

Thanks

Vikas

[Nolgath]

I get duplicate values tho now.. why?

[Lokesh_5045]

@Nolgath , try Load distinct .