topic Re: optimize multiple concatenate in QlikView

optimize multiple concatenate

federicacci — Tue, 14 Mar 2017 10:24:26 GMT

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

Re: optimize multiple concatenate

sunny_talwar — Tue, 14 Mar 2017 10:37:15 GMT

Are you talking about a optimized qvd load here?

Re: optimize multiple concatenate

federicacci — Tue, 14 Mar 2017 10:42:22 GMT

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

Re: optimize multiple concatenate

sunny_talwar — Tue, 14 Mar 2017 10:43:17 GMT

Have you looked at this this thread?

Turning Unoptimized Loads into Optimized Loads