Multiple joins in single QVD Tab

[ashishpalkar]

Hi There

I have below requirement.

I have 5 Tables

Table1

           (ID -> Primary Key) - Fact Table

           ID1  

           ID2

           ID3

           ID4

Table2 (ID1 ->Primary Key) -

Table3 (ID2 ->Primary Key)

Table4 (ID3 ->Primary Key)

Table5 (ID4 ->Primary Key)

Table 2 to 5 are connected with Table 1 using above respected ID's. How can we use this in one single QVD?

Thanks in advance,

[sunny_talwar]

Are you trying to save these 5 tables in a single QVD file? If you are then just perform a (Regular, Left, Right or Inner) Join operation to create one table out of the 5 and save them in a qvd.

[sunny_talwar]

[Peter_Cammaert]

If you're looking for a way to store an entire data model in a single QVD, why not store it in a headless QVW and perform a BINARY load whenever you need the data somewhere else?

Peter

[ashishpalkar]

Hi Peter

Thanks for updates , what is headless QVW?

[SreeniJD]

Hi Ashish -

In general, an application is a QlikView file that is used as a ‘headless’ (i.e. UI-less) optimized application containing data– known as a .qvd file. it’s important for those responsible for the deployments to employ a multi-tiered data and application architecture approach

HTH

Sreeni

[ashishpalkar]

thanks Sreeni for updates, can you send me any sample file with mentioned criteria.

(I have created 5 different QVD's and then joining these QVD's with appropriate Primary keys)

[ashishpalkar]

Thanks Sunny.