Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

optimize multiple concatenate

Hi all,

I need to optimize a multiple concatenate.

The situation is the following:
Table 1: result of concatenation of 3 identical files with 13 fields.
I want to concatenate to Table 1, other 3 identical files that have 12 fields each, mostly different from those in the Table 1.

I tried to concatenate the first 3 identical files, then the other 3 files with each other, and finally the two tables together, but I had to do a re-reading!
You have a better solution?


Thanks


3 Replies
Highlighted

Re: optimize multiple concatenate

Are you talking about a optimized qvd load here?

Highlighted
Contributor
Contributor

Re: optimize multiple concatenate

Yes, my qvds are very big, and I would like to optimize the concatenation so quickly conclude loading.

Highlighted

Re: optimize multiple concatenate

Have you looked at this this thread?

Turning Unoptimized Loads into Optimized Loads