Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
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