Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load a set of excel file in a directory

Hello :);

I want to load a set files excel with same structure in a directory. for this i use this scrpit:

Table1:

LOAD

Field

FROM (biff, embedded labels, table is Sheet1$); // Load xls format files

Concatenate

LOAD

Field



FROM (ooxml, embedded labels, table is Sheet1); // load xlsx format files.



My problem is if there are no files in ma directory (xls or xlsx) i have an error, how can i check the presence of a file before start loading.

Best regards.

10 Replies
Not applicable
Author

sorry,

execute cmd.exe /c move C:\Src\export.xls c:\target