Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Issue of loading the data

Assume that I do have two tables.

Table1:

IDAC
1AC
2AC
3AC

Table2:

IDAB
2AB
4AB
5AB

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!

1 Solution

Accepted Solutions
Anonymous
Not applicable

try to use exists:

Tab1:

load ID,

A,

C

Tab2:

load ID,

A,

B

from

where not exists (ID)

View solution in original post

5 Replies
Anonymous
Not applicable

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
Master II
Master II

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
Partner - Specialist III
Partner - Specialist III
Author

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?

Screenshot_1.jpg

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);