Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

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

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

 

1 Solution

Accepted Solutions
Highlighted
Master
Master

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

View solution in original post

6 Replies
Highlighted
Specialist II
Specialist II

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

Highlighted
Master
Master

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. 

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Master
Master

Hi Sir

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

Paul
Highlighted
Creator
Creator

 

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

Highlighted
Master
Master

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

View solution in original post