topic Re: Need help around Exists and Not exists in QlikView

Need help around Exists and Not exists

Mon, 22 Jul 2013 11:05:15 GMT

Pl find below my script script content. I want to understand where not exists(deptid) functionality here.

Does this mean, the Deptid which is there in dept11.qvd (refer below the Concatenate) is not there in Dept.xlsx then merge these data ??

Can someone pl explain on this ? If its EXISTS what will happen ??

Inc:

LOAD Deptid as Dep,

Deptname,

Location,

last_upd

FROM

$(SD)Dept.xlsx

(ooxml, embedded labels, table is Delta)

WHERE last_upd >= $(vmaxdt);

Concatenate

LOAD Deptid,

Deptname,

Location,

last_upd

FROM

$(SD)dept11.qvd(qvd)

WHERE NOT EXISTS(Deptid);

Re: Need help around Exists and Not exists

Mon, 22 Jul 2013 11:07:57 GMT

see attached file for your help

POTENTIAL_QVD:

LOAD * INLINE [

id,name

1, dddk

2,cck

];

join

POTENTIAL_EXCEL:

LOAD * INLINE [

id,name

1, dk

2,cck

3,ab

4,cd

]Where not Exists(id);

Re: Need help around Exists and Not exists

Mon, 22 Jul 2013 11:09:48 GMT

Attachment is missing , I guess.

Is that a word doc ?? I can't open .qvw file

Re: Need help around Exists and Not exists

kaushiknsolanki — Mon, 22 Jul 2013 11:10:16 GMT

Hi,

This script says.

First load the data from excel.

Now load the data from QVD but only the Deptid which is not loaded earlier.

Let me explain with example.

Say I load Country (INDIA,US) earlier from a QVD.

Now I need to get the country which is not (INDIA and US)

So i will use not Exist function.

Which says dont load the data which is loaded earlier.

Hope this is clear.

Regards,

Kaushik Solanki

Re: Need help around Exists and Not exists

Mon, 22 Jul 2013 11:27:56 GMT

Thanks once again Kaushik.

Thanks much Vish - I tried your sample data , now am clear..

Just to conclude:

TableA

Concatenate

TableB

Where not exists (id)

Exclude the values in B if its already there in A while joining with Table A