Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
ksomosera10
Contributor II

2 Existing QVD to Generate 1 QVD

Hi,

I just need some help on working with QVD's. Here's my scenario...

I create 1 QVW that generate 2 QVD's (Let's Say 'QVD1' and 'QVD2'). Now, I want them to merge into a single QVD ('TOTALQVD').

Now QVD1 and QVD2 has a connecting Fields(Let's call it FieldKey) Now, Can you help me how I can generate "TOTALQVD" and use it my other reports?

Here's how I generate the two QVD's:

[QVD1]:

LOAD *;

SQL EXEC [dbo].[usp_QVD1];

STORE [QVD1] INTO qvd1.qvd;

[QVD2]:

LOAD *;

SQL EXEC [dbo].[usp_QVD2];

STORE [QVD2] INTO qvd2.qvd;

Can you help me how I can add a script to combine these two QVD's?

THANKS!

Tags (3)
1 Solution

Accepted Solutions
Highlighted
ahaahaaha
Honored Contributor

Re: 2 Existing QVD to Generate 1 QVD

Hi

May be like this

[QVD1]:

LOAD *;

SQL EXEC [dbo].[usp_QVD1];

LEFT JOIN

LOAD *;

SQL EXEC [dbo].[usp_QVD2];

STORE [QVD1] INTO qvd1.qvd;


Regards,

Andrey

View solution in original post

4 Replies
Highlighted
ahaahaaha
Honored Contributor

Re: 2 Existing QVD to Generate 1 QVD

Hi

May be like this

[QVD1]:

LOAD *;

SQL EXEC [dbo].[usp_QVD1];

LEFT JOIN

LOAD *;

SQL EXEC [dbo].[usp_QVD2];

STORE [QVD1] INTO qvd1.qvd;


Regards,

Andrey

View solution in original post

Highlighted
ksomosera10
Contributor II

Re: 2 Existing QVD to Generate 1 QVD

WOW! It worked! Thanks!...

BTW, Just to tickle my mind... what happened if I add or I have another QVD? Let's say 'QVD3'?

Does my script would be like this?

[TOTALQVD]:

LOAD *;

FROM totalqvd.qvd(qvd);


LEFT JOIN

LOAD *;
SQL EXEC [dbo].[usp_QVD3];

STORE [TOTALQVD] INTO totalqvd2.qvd;


I hope I'm right

Highlighted
ahaahaaha
Honored Contributor

Re: 2 Existing QVD to Generate 1 QVD

Yes, you are right, if in QVD3 there is also only one coinciding field [FieldKey] and other fields have different names from QVD1, QVD2.

ksomosera10
Contributor II

Re: 2 Existing QVD to Generate 1 QVD

thanks!