topic Re: Problem with FOR_EACH loop in QlikView

Problem with FOR_EACH loop

datanibbler — Tue, 17 Mar 2015 08:58:51 GMT

Hi,

I have some issue with a FOR EACH loop. It's not the first time I use it, but I guess it's some stupid little mistake.

I will just post my code here.

The issue is, in this directory there's files in .xls format and some in .xlsx format, so I guess I will need two loops. The first one should go after the .xlsx files - but apparently, nothing is found to match, the loop is simply skipped.

DIRECTORY '~~'; // In this directory, there should be 2 files with the ending .xlsx;~~

// The file_path is correct, I have tested it.

SET v_Filemask = 'Staplerliste*.xlsx';

FOR EACH v_File IN FileList ('$(v_Filemask)')
Hilfstab_pre:
FIRST 1 LOAD
FileName() as Dateiname
From
$(v_File) (ooxml, no labels);
NEXT v_File

Can anyone spot the error here?

Thanks a lot!

Best regards,

DataNibbler

Re: Problem with FOR_EACH loop

jonathandienst — Tue, 17 Mar 2015 09:05:23 GMT

Looks OK to me, except possibly for the (unnecessary) decoration in the DIRECTORY line (the square brackets and quotes are not required). If the XLS loop works using the same logic, then that is probably not the problem.

HTH

Jonathan

Re: Problem with FOR_EACH loop

marcus_sommer — Tue, 17 Mar 2015 09:07:52 GMT

Hi DataNibbler,

I assume that filelist need a fullpath and didn't regognize a directory-statement.

- Marcus

Re: Problem with FOR_EACH loop

jonathandienst — Tue, 17 Mar 2015 09:08:50 GMT

Try replacing the variable with:

FOR EACH v_File IN FileList ('S:\Common\31 Maintenance\Stapler\Staplerliste*.xlsx')

or use one of the known filenames to test (ie not using wildcards)

Your From statement should read:

From [$(vFile)]

as their is a space in the path name.

Jonathan

Edit = I think Marcus is correct

Re: Problem with FOR_EACH loop

datanibbler — Tue, 17 Mar 2015 09:12:50 GMT

Hi Marcus,

that is a valid assumption - but no, it doesn't. I have several other FOR EACH loops where I use the DIRECTORY and then a filelist which only holds the filename itself.

I will look for another way to do this.

It is possible to use the * just for the middle part of a file_name and specify something at the end, isn't it
(like >> Staplerliste*(Master) <<)

to rule out files that have something more behind that > (Master) < in the file_name.

Best regards,

DataNibbler

Re: Problem with FOR_EACH loop

marcus_sommer — Tue, 17 Mar 2015 09:28:03 GMT

In general it should work - I guess there is a small syntax issue, maybe with the directory and/or the variable-staement, try to trace the path to see what is wrong. This for example worked:

Sub DoDir(Root)

for each Ext in 'qvw', 'qvd' //, 'qvo', 'qvs', 'qvt', 'txt', 'csv', 'xls', 'xlsx'

for each File in filelist (Root&'\*.'&Ext)

.....

- Marcus