Join tables

[AmCh]

Hi all,

I have two excel files: piece1 and piece2. Each of them has three columns: name, value and reference.

I want to generate only one table joining tables from piece1 and piece2 with the three columns name, value and reference.

Any help please?

Thanks in advance.

[Vegar · Accepted solution]

IF you want to join then you could do this

piece:
LOAD name, value, reference
FROM piece1;

JOIN (piece) 
LOAD name, value  reference
FROM piece2;

Another approach combining them could be concatenating. From you description concatenation could be the approach you are looking for.

piece:
LOAD name, value, reference
FROM piece1;

Concatenate (piece) 
LOAD name, value  reference
FROM piece2;