topic select files with Wildcard in QlikView

select files with Wildcard

Fri, 25 Oct 2013 20:20:10 GMT

Hi all,

I am trying to select files from file share:

LOAD

FROM

(ooxml, embedded labels, header is 1 lines, table is Quote);

I would like to ignore all the files which dont start with alphabet ad first character. Reason office files create a temporary file which qlikview also try to parse and load and error out.

is there a way to select only files where in name first alphabet is a character.

regards

ravi

Re: select files with Wildcard

p_verkooijen — Fri, 25 Oct 2013 20:29:15 GMT

You could check the first character using for each file in filelist.

you can also disable errors for the xlsx reload. The reload will continue even if errors occur.

SET ErrorMode = 0;

Load * from f:\test\*.xlsx (ooxml, embedded labels, header is 1 lines, table is Qoute);

SET ErrorMode = 1;

Re: select files with Wildcard

Tue, 07 Feb 2017 15:06:03 GMT

thats work for me, thank you.