Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
craig157
Creator II
Creator II

Joining of Multiple QVDs

Hi All,

So I've got a couple QVDs that are created from another Qlikview Project.

Now in my project I will be loading these QVDs and all the tables have one field that relates to all "OrgId"

What would be the best way to join these all as just now it won't let me load even the second table.

Please see below current script:

OrganisationS2:

LOAD *

From [S1-Organisation.qvd] (qvd);

FullOrganisation:

Left Join (OrganisationS2)

LOAD *

From [S1-OrganisationHistory.qvd] (qvd);

FullerOrganisation:

Left Join (OrganisationS2)

LOAD *

FROM [S1-OrganisationContact.qvd] (qvd);

MarketingCampaignsS2:

Left Join (OrganisationS2)

LOAD *

FROM [S1-MarketingCampaigns.qvd] (qvd);

Hopefulyl an easy fix

Thanks

13 Replies
prieper
Master II
Master II

Did you try to load the files individually, i.e. without JOINing?
Did you try to load only the first 100 rows and then check the joins - or synthetic keys - as the case maybe?

craig157
Creator II
Creator II
Author

Hi All,

So turns out nothing needed changed - the second QVD had corrupt data so just required a reload in the other Database.

Thanks for you help though!

Cheers

Craig

Peter_Cammaert
Partner - Champion III
Partner - Champion III

So it was like I thought here: Re: Joining of Multiple QVDs

If your issue has been resolved, please close the discussion by marking posts as Correct or Helpful. That way other community members looking for a solution to a similar situation will find an answer. Thanks

craig157
Creator II
Creator II
Author

Completely Peter! Thanks!