topic find directory is empty or not in QlikView

find directory is empty or not

pavansonu99 — Wed, 25 Nov 2020 16:16:04 GMT

can someone help me with script to know whether the directory is empty or not

my requirement is lo load only if the directory is empty.

Re: find directory is empty or not

marcus_sommer — Sun, 15 Jan 2017 09:36:39 GMT

You could run a loop with filelist() over your directory and if filesize() or maybe an own counter is 0 then the directory is empty or contained not the searched files. A good description of them could you find within the help by "for each ..." and also here: Loops in the Script.

- Marcus

Re: find directory is empty or not

girirajsinh — Sun, 15 Jan 2017 10:53:37 GMT

Hi Pavan

Below script works for me. I hope it will work for you as well. Please try.

SET vPathQvd = 'D:\Girirajsinh\temp\*';

TempTable:
load
count(distinct FileName()) as FN
From [$(vPathQvd)] (biff, embedded labels, table is Sheet1$);

Let vCNT=Peek('FN');

if cnt>0
EXIT SCRIPT;
ELSE
// Wrie here your LOAD
ENDIF

Re: find directory is empty or not

vinieme12 — Sun, 15 Jan 2017 11:49:46 GMT

Try below

Let vFileCount = 0;

For Each vFile in FileList('C:\Users\Vini\Downloads\*')

Let vFileCount = $(vFileCount) + 1;

IF $(vFileCount) = 0 THEN

//Your Script

End IF

Re: find directory is empty or not

pavansonu99 — Sun, 15 Jan 2017 16:36:19 GMT

Thank u Vineeth ur code worked for my requirement.

Re: find directory is empty or not

vinieme12 — Sun, 15 Jan 2017 17:34:27 GMT

Glad to help,

If your query is resolved please close the thread by marking response as correct

Qlik Community Tip: Marking Replies as Correct or Helpful