topic Re: Joining of Multiple QVDs in QlikView

Joining of Multiple QVDs

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Joining of Multiple QVDs

jonathandienst — Fri, 08 Sep 2017 08:59:25 GMT

And what error message por other output do you get if "it won't let me load even the second table"?

Its impossible to diagnose a problem with the scant information you have provided.

Re: Joining of Multiple QVDs

Kushal_Chawda — Fri, 08 Sep 2017 09:04:17 GMT

I did not understand what you are trying to say. Can you please elaborate?

Re: Joining of Multiple QVDs

craig157 — Fri, 08 Sep 2017 09:05:02 GMT

There is no error produced, the Reloader Finishes running and no data is loaded from the 2nd qvd "[S1-OrganisationHistory.qvd] (qvd);"

If I had received an error I would have posted in Jonathan

Re: Joining of Multiple QVDs

craig157 — Fri, 08 Sep 2017 09:08:20 GMT

No more details received and then advised Execution of Script failed - reload old data

Re: Joining of Multiple QVDs

afsarshaikh — Fri, 08 Sep 2017 09:19:41 GMT

First of all, didn't understand your question. However, could you please try this,

OrganisationS2:

LOAD *

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

Left Join (OrganisationS2)

FullOrganisation:

LOAD *

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

Left Join (OrganisationS2)

FullerOrganisation:

LOAD *

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

Left Join (OrganisationS2)

MarketingCampaignsS2:

LOAD *

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

I hope you've proper joining keys in all the table and hopefully this works!

Re: Joining of Multiple QVDs

Kushal_Chawda — Fri, 08 Sep 2017 09:28:43 GMT

Please check the Key field has same Name in all the table if not you have to rename it

Re: Joining of Multiple QVDs

buzzy996 — Fri, 08 Sep 2017 10:15:21 GMT

hello,u have to use either any type of join/keep or concatenate based on what type of data you want to see as a output.

so,as per the inputs u provided it's difficult to everyone/not possible to answer ur query.

Re: Joining of Multiple QVDs

Peter_Cammaert — Fri, 08 Sep 2017 11:37:58 GMT

It could be that your QVD file S1-OrganisationHistory.qvd is either empty or corrupt. Can you create a test QVW that simply tries to load all data from this QVD file?

Re: Joining of Multiple QVDs

prieper — Fri, 08 Sep 2017 12:07:29 GMT

You should not place the tablename within the LOAD-sequence?

Re: Joining of Multiple QVDs

prieper — Fri, 08 Sep 2017 12:08:53 GMT

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?

Re: Joining of Multiple QVDs

craig157 — Fri, 08 Sep 2017 14:05:30 GMT

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

Re: Joining of Multiple QVDs

Peter_Cammaert — Fri, 08 Sep 2017 14:33:30 GMT

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

Re: Joining of Multiple QVDs

craig157 — Fri, 08 Sep 2017 14:35:37 GMT

Completely Peter! Thanks!