topic Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file. in QlikView

After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

paulyeo11 — Fri, 13 Jan 2017 00:26:18 GMT

Hi All

I like to change the folder name for save my excel file , so easy maintenance.

Now it save at C:\TEST

I have add below line :-

SET vInputPath = 'C:\TEST\EXCEL'; //local folder

Then i move the excel file to C:\TEST\EXCEL

Now when i run load script , i get error msg :-

Cannot open file 'C:\TEST\filelist.xlsx'

I found below script there is vRAWPath :-

if(subfield('$(vFileName)','.',1) = '$(vRAWPath)$(vFile)') then

So i change to :-

if(subfield('$(vFileName)','.',1) = '$(vInputPath)$(vFile)') then

I still get the same error msg :-

Cannot open file 'C:\TEST\filelist.xlsx'

I get stuck and unable to move forward.

Now i comment on the last script i modify , and copy excel file back to org folder and reload , it is okay.

Hope some one help me.

My QVW and ra data and excel file can be doanload from below link :-

https://community.qlik.com/thread/245998

Paul

Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

paulyeo11 — Fri, 13 Jan 2017 00:28:01 GMT

Enclosed my QV file.

Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

MarcoWedel — Fri, 13 Jan 2017 00:33:43 GMT

are you still using

For each vFileName in FileList('$(vRAWPath)*.txt')

in your script like you did in your other thread?

You might have to change the vRAWPath variable into vInputPath there as well.

hope this helps

regards

Marco

Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

paulyeo11 — Fri, 13 Jan 2017 00:51:49 GMT

Hi Marco

Thank you very much for your sharing .

I am aware of what you said.

As I have already search thru and I have already add the Nee excel folder and also change declare the new path for excel file folder and yet I still get error.

May be still there are some where I need to change.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

stabben23 — Fri, 13 Jan 2017 07:07:49 GMT

Why not use the thread you start With!!

I can help if you use the same thread, I have help you a lot in this but you start New threads over and over again.

You need to have the excellist in the same folder as you .txt files, otherwise it will be needed some fixes.

Re: After i add SET vInputPath = 'C:\TEST\EXCEL'; I get error msg unable to open my excel file.

paulyeo11 — Fri, 13 Jan 2017 07:12:52 GMT

Hi Staffan

I will go back to old thread to post this similar question.

Thank you for your help.

Paul Yeo