topic Re: Join question in QlikView

Join question

Sat, 15 Mar 2014 10:36:23 GMT

Hi guys,

I have one QVD file which got unique IDs....

now i got one source table in my database with following unique Ids.

I need to update my QVD file by performing a subtraction kind of operation...

so that my QVD file should have

it is like QVD - Source.

Is it possible?

Saurabh

Re: Join question

veidlburkhard — Sat, 15 Mar 2014 10:46:42 GMT

Hi Ramya,

you can do this in your script like this:

ID_Long:

LOAD * INLINE [

];

NoConcatenate

ID_Short:

LOAD ID

Resident ID_Long Where ID < 4;

DROP Table ID_Long;

STORE ID_Short into ID_Short.qvd;

Hope this helps

Burkhard

Re: Join question

Miguel_Angel_Baeyens — Sat, 15 Mar 2014 10:47:23 GMT

Hi,

It is possible using EXISTS() clause in the WHERE load statement:

Source:
LOAD ID;
SQL SELECT ID FROM TABLE; //whatever the source it is

QVD: // load only interesting records
LOAD ID
FROM File.qvd (qvd)
WHERE NOT EXISTS(ID);

DROP TABLE Source;

Miguel

Re: Join question

Sat, 15 Mar 2014 11:13:30 GMT

It seems to be a right answer...

I will try and will let you know...

Re: Join question

SunilChauhan — Sat, 15 Mar 2014 16:29:32 GMT

You should use this

table1:

LOAD * INLINE [

];

table2:

LOAD * INLINE [

ID1

];

NewTab1:

Load ID,

1 as J

Resident table1;

NewTab2:

Load ID1,

1 as K

Resident table2 where not Exists(ID,ID1);

drop table table1,table2,NewTab1;