Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I could yes but when i click reload the Qlikview will be unable to find the files I have moved, unless im missing something.
I don't understand your problem. Are you saying that when you change the load statement to load from a different excel file that Qlikview still also loads from the file specified before you changed the script?
No, I am running a test model which outputs a spreadsheet. the spreadsheet(s) are then loaded into qlikview. when i run a new test i want to be able to load the new spreadsheet into Qlikview without loading those that are already in.
And you can't simply use one source location and move the files elsewhere after loading the data into Qlikview?
I could yes but when i click reload the Qlikview will be unable to find the files I have moved, unless im missing something.
I think Ive sussed it, what im after is partial reload and ADD not incremental, thanks for replying
Then don't move them and use a wildcard to load them all.
LOAD * FROM
Or am I misunderstanding you again?