Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QlikView addicts,
I have the next question.
I'm using a For Next loop to load several QVD files into a QVW. The loop runs 3 times.
However, in the 2nd time the loop goes wrong.
The reason is that I use joins and concatenate so at 2nd loop some tables can not be found.
However I do not know how I should fix?
Can someone help me.
thank you so much
What is the script? If possible attach sample file.
Jagan,
first thank you for your time.
I added 2 zip files.
- Example Loop; This is a QVW file with a simple sample what goes wrong. It's not te original file but if I can make this example work I can also make the original work.
- Example QVD's; These are the 4 QVD that you need for reloading
When you comment the For Next code QlikView wil automtic concatenate the tables because all the fields are the same,
but if you uncomment the For Next code you will see that he will create double tables because with the second time (loop) he can't find certain tables because in the first loop there were concatenated.
I hope I did described it well.