Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rofa84
Contributor II
Contributor II

Connection not found

Hello,

I used,

LET vFilePath = 'lib://brbrs003/pub\DBILL\REPORTS\Monthly\Metrics';

and This is the error message I got,

The following error occurred:
Connection not found: brbrs003
The error occurred here:
FOR EACH file in FileList('lib://brbrs003/pub\DBILL\REPORTS\Monthly\Metrics/*.xls')
 
I've tried several methods but I can't figure out why it's keep prompting me this message.
Please help. 
 
Best, 
 
John
3 Replies
JordyWegman
Partner
Partner

Hi Rofa,

Try this:

For each file in FileList('lib://brbrs003/pub\DBILL\REPORTS\Monthly\Metrics\*')
TEMP_FILE:
LOAD
   subfield('$(file)','\',-1) as filename,
   FileTime('$(file)') as Date_file autogenerate 1;
Next;

Jordy

Climber

Work smarter, not harder
rofa84
Contributor II
Contributor II
Author

Thank you for the reply,

but I'm still getting the same error message.

JordyWegman
Partner
Partner

What if you use $(vFilePath) in your FileList?

Jordy

Climber

Work smarter, not harder