Issue of loading the data

[MindaugasBacius]

Assume that I do have two tables.

Table1:

ID	A	C
1	A	C
2	A	C
3	A	C

Table2:

ID	A	B
2	A	B
4	A	B
5	A	B

My task is to concatenate both tables with one option.

I have to remove all the IDs from Table2 that are the same in Table1.

I am looking for most efficient way to do that.

Thank you for your ideas!

[Anonymous · Accepted solution]

try to use exists:

Tab1:

load ID,

A,

C

Tab2:

load ID,

A,

B

from

where not exists (ID)

[marcus_sommer]

Something like this:

t:

load * From Table1;

     concatenate

load * From Table2 where not exists(ID);

- Marcus

[trdandamudi]

May be like below:

Table1:

Load * Inline [

ID,A,C

1,A,C

2,A,C

3,A,C

];

Concatenate

Table2:

Load * Inline [

ID,A,B

2,A,B

4,A,B

5,A,B

]

Where not Exists(ID);

[MindaugasBacius]

LOAD ID
FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate
Table2:
LOAD B as ID
FROM

(ooxml, embedded labels, table is Sheet2)
where not exists(ID);

Why do I get the error while renaming the fields?

[sunny_talwar]

Try this:

LOAD ID
FROM 
(ooxml, embedded labels, table is Sheet1);

Concatenate
Table2:
LOAD B as ID
FROM 
(ooxml, embedded labels, table is Sheet2)
Where not Exists(ID, B);