topic Any restrictions are needed for concatenate function? in QlikView

Any restrictions are needed for concatenate function?

siva_boggarapu — Tue, 16 Aug 2011 12:10:33 GMT

Hello everybody,

I have 10 qvd files. I want to make them into single qvd using concatenate function. But all 10 qvd files are dismilar fields. Is it possible to make single qvd for all 10 qvds?

thanks in advance.

Re: Any restrictions are needed for concatenate function?

its_anandrjs — Tue, 16 Aug 2011 12:25:27 GMT

Hi,

Yes you are able to create a single qvd by the 10 qvds but in this case you need to concatenate load all 10 tables then create a single qvd but in this case you need to handle null values because each table has disimilar fields.

Tab1:

load * inline

[

ColA,ColB

w,2

s,3

d,1

];

Concatenate

load * inline

[

ColC,ColD

u,7

i,6

o,5

];

Store Tab1 into Tab1.qvd;

Try to load by this code.

Hope this helps you.

Regards,

Anand

Any restrictions are needed for concatenate function?

siva_boggarapu — Tue, 16 Aug 2011 12:35:57 GMT

Hello Anand,

Thanks for giving replay

I tried with same way what you suggest. Table are also getting reloading and finally qvd also created. Here the proble is comming. I am unbale to open final qvd. What the porblem?

Re: Any restrictions are needed for concatenate function?

its_anandrjs — Tue, 16 Aug 2011 12:52:13 GMT

Hi,

You need to see your QVW application saved location on the folder where your QVW file is kept always a qvd file is create there. A qvd file Tab1.qvd is kept there after that you need to load it as a Table files from script window.

Regards,

Anand