Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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
Completely Peter! Thanks!