Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
fabb95501
Partner - Contributor III
Partner - Contributor III

Issues in data connection name

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

1 Solution

Accepted Solutions
anuragprasad
Partner - Contributor II
Partner - Contributor II

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

1 Reply
anuragprasad
Partner - Contributor II
Partner - Contributor II

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