When i modify excel file name from from A to B , i reload Qlik view still look for A.xlsx ?

[paulyeo11]

Hi All

I have below script :-

MapDesc:
mapping LOAD
[Brand_],
[SubBrand_]
FROM A.xlsx (ooxml,embedded labels, table is [Brand_TDS]);

When i try to change the above excel file name from A to B. ( I also rename my excel file name from A to B  )

When i reload my script , i get error msg on it cannot find A.xlsx

May i know how to solve this issue ?

Paul

[anushree1]

Try going to the table through script and see if the data path and file name are same

[paulyeo11]

Hi Sir 

Thank you very much for your sharing.

i am not quite sure what you mean ? 

By the way my issue is when in the load script file = A is running fine.

i go to my file , rename the file from A to B.

And I also go to load script change from A to B.

when I reload script , it still display unable to find file A. 

[Brett_Bleess]

Are you saving the file after you make the change to the script?  I believe the change should be locked in when you ok out of the script editor though.  It would appear something is getting cached in your case, so I would try making the changes, save the file close the client, then reopen things and see what you have and then run the reload again and see if things run.  What I would like to see if you still get the error is the Script log:

Enable script/document log

You could also try to run things via the Script Debugger, and step through line by line to try to see what shows up there as well.  

Regards,
Brett

[paulyeo11]

Hi Sir

Thank you for give me so many hints. I try when this happen again.

Paul

[ljackson]

Check your worksheet name is the same in the new file B,  the script states it should be 'Brand_TDS'

[paulyeo11 · Accepted solution]

Hello

I found an alternative solution that is I create file 1 = sales order data.txt

This way it have 2 advantages:-

I can open the text file while I reload
Above issue will have no problem .

Paul