Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
thats work for me, thank you.