Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a folder that contains multiple excel files. Part of the file name will always be consistent and I want to load a set of the files based on this string found in the file name.
For example the file name is
CGCAHPS Adult__Dimensions __Cal Q3 2019 (July - September).xlsx]
I want the From statement to only load the files that have CGCAHPS Adult in the file name.
I tried *CGCAHPS Adult*.xlsx and that doesn't work.
Just use the * at the end like this :
FROM [lib://LIB_NAME/CGCAHPS Adult*.xlsx]
I tried that and I get an error that it can't open the file.
(Native Path: ***
System error: ***)
Can you insert the code , and print of error and the folder.