Issues in data connection name

[fabb95501]

Hi all,

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')

Table:
LOAD

Field1,

Field2

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?

Fabio

[anuragprasad · Accepted solution]

Go to QMC -> Data Connections. You can edit the connection name from there after clicking on the concerned Data connection