Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner
Partner

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)

View solution in original post

marcus_sommer
MVP & Luminary
MVP & Luminary

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