Issues in data connection name

fabb95501 — Fri, 15 Jan 2021 11:00:48 GMT

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

Re: Issues in data connection name

anuragprasad — Fri, 15 Jan 2021 16:55:16 GMT

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