Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
sorry,
execute cmd.exe /c move C:\Src\export.xls c:\target