Join tables

AmCh — Wed, 18 Aug 2021 12:18:07 GMT

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.

Re: Join tables

Vegar — Wed, 18 Aug 2021 12:28:15 GMT

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;