topic Issue in using Exists clause. in QlikView

Issue in using Exists clause.

Mon, 03 Mar 2014 07:31:32 GMT

Dear All,

I am new to QLICKVIEW.

PFB snapshot of code that i have written.

I am trying to test EXISTS functionality but getting error :

Cannot open file 'C:\Program Files\QlikView\Tutorial\MyWorks\Inter Record Functions\Citizens.csv

where not exists' The filename, directory name, or volume label syntax is incorrect.

Directory;
LOAD Employee,
ID,
Salary
FROM
Exists.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

load Name, Number from Citizens.csv
where not exists(Name);

Pls help me in resolving this error.

Re: Issue in using Exists clause.

MK_QSL — Mon, 03 Mar 2014 07:34:07 GMT

This error comes if you are using Relative Paths and the QVW and Your Data File are not on the same folder

Reload the file by removing Relative paths or If you want to use Relative Path save the QVW in the same folder where your DATA FILE exists

Also change as below..

where not exists(Employee,Name);

where exists(Employee,Name);

Re: Issue in using Exists clause.

Mon, 03 Mar 2014 07:39:55 GMT

Hi Manish,

Error i am getting is :

Cannot open file 'C:\Program Files\QlikView\Tutorial\MyWorks\Inter Record Functions\Citizens.csv where not exists' The filename, directory name, or volume label syntax is incorrect.

It is treating where not exists to be part of file name.

Also i have checked, all data files and qvw files are in same folder.

Re: Issue in using Exists clause.

Mon, 03 Mar 2014 07:45:10 GMT

does this work?

load Name, Number where not exists(Name); select * from C:\lalalla\Citizens.csv

Re: Issue in using Exists clause.

Mon, 03 Mar 2014 07:52:41 GMT

modified code as per your suggestion :

load Comment where exists(Employee,FirstName);

select * from C:\Program Files\QlikView\Tutorial\MyWorks\Inter Record Functions\Citizens.csv

error now is :

ODBC connection failed

select * from C:\Program Files\QlikView\Tutorial\MyWorks\Inter Record Functions\Citizens.csv

Re: Issue in using Exists clause.

Mon, 03 Mar 2014 08:02:16 GMT

yes my bad:

try this remember to change ur own path

LOAD name,

number

FROM

(txt, codepage is 1252, embedded labels, delimiter is ';', msq) where not Exists(name);

Re: Issue in using Exists clause.

Mon, 03 Mar 2014 08:07:09 GMT

Hi Thomas,

Thanks for your solution.

It works now.

Thanks again !!