Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
try to use exists:
Tab1:
load ID,
A,
C
Tab2:
load ID,
A,
B
from
where not exists (ID)
try to use exists:
Tab1:
load ID,
A,
C
Tab2:
load ID,
A,
B
from
where not exists (ID)
Something like this:
t:
load * From Table1;
concatenate
load * From Table2 where not exists(ID);
- Marcus
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);
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?
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);