Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;