Issue in using Exists clause.

[#1]

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.

[MK_QSL]

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

or

where exists(Employee,Name);

[#3]

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.

[#4]

does this work?

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

[#5]

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

[#6 · Accepted solution]

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

[#7]

Hi Thomas,

Thanks for your solution.

It works now.

Thanks again !!