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

[paulyeo11]

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

[paulyeo11]

Enclosed my QV file.

[MarcoWedel]

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

[paulyeo11]

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

[stabben23]

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.

[paulyeo11]

Hi Staffan

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

Thank you for your help.

Paul Yeo