Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
siva_boggarapu
Contributor II

Any restrictions are needed for concatenate function?

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.         

3 Replies

Re: Any restrictions are needed for concatenate function?

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

siva_boggarapu
Contributor II

Any restrictions are needed for concatenate function?

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?

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

Community Browser