Discussion board where members can learn more about Qlik Sense Data Connectivity.
I'm trying to load multiple Excel files from a directory.
This is the load script:
For each vFileName in Filelist ('lib://Data (srv_developer)/2021/Forecast/*.xlsx')
FROM $(vFileName)(ooxml, embedded labels, header is 2 lines, table is [Forecast AU]); Next vFileName;
But the round brackets into the directory path causes this error:
"Unexpected token: 'srv_developer', expected one of: 'symbol', 'biff', 'dif', 'fix', 'html', 'json', 'kml', …"
I can't rename the folder path, so how can I solve this issue?
Go to QMC -> Data Connections. You can edit the connection name from there after clicking on the concerned Data connection
View solution in original post