Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to load data from all the xls in the below folder. But it is loading data from xlsm which exists in one of the below folder. How can I skip xlsm from below and load only from xls?. Please help!
SET ZLoadDirectory = 'C:\data\xyz';
FOR each File in filelist (ZDirectory & '\*.xls')
Load ....
;NEXT File
Add a where clause to the load : Where FileExtension() <> 'xlsm'
(Required to be done in the LOAD because returned at the record level.)
Otherwise you can use a IF:
IF subfield(File, '.', 2) <> 'xlsm' THEN
LOAD ...;
END IF
Next
Hi qlikviewforum
When I tested your code I was able to fetch only "xlsx". Automattically it skips the "xlsm".So can you confirm once again,if still you have the problem
LOAD *,
Filename() as File_Info
FROM
[Desktop\QV E books\Data\*.xlsx]
(ooxml, embedded labels, table is Sheet1);
-Jay
Hi Luis,
I've tried to add below script to skip the file, but why I got Script line error.
Regards,
Catherine