Connection not found

[rofa84]

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

[JordyWegman]

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

[rofa84]

Thank you for the reply,

but I'm still getting the same error message.

[JordyWegman]

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

Jordy

Climber