Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jjordaan
Partner - Specialist
Partner - Specialist

Error in For next loop because of the use of Concatenate en Joins

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

2 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

What is the script? If possible attach sample file.

jjordaan
Partner - Specialist
Partner - Specialist
Author

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.