topic Re: Issue of loading the data in QlikView

Issue of loading the data

MindaugasBacius — Wed, 08 Jun 2016 13:43:34 GMT

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!

Re: Issue of loading the data

Anonymous — Wed, 08 Jun 2016 13:51:50 GMT

try to use exists:

Tab1:

load ID,

Tab2:

load ID,

from

where not exists (ID)

Re: Issue of loading the data

marcus_sommer — Wed, 08 Jun 2016 13:52:57 GMT

Something like this:

load * From Table1;

concatenate

load * From Table2 where not exists(ID);

- Marcus

Re: Issue of loading the data

trdandamudi — Wed, 08 Jun 2016 13:53:21 GMT

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

Re: Issue of loading the data

MindaugasBacius — Wed, 08 Jun 2016 14:14:44 GMT

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?

Re: Issue of loading the data

sunny_talwar — Wed, 08 Jun 2016 14:24:09 GMT

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