Joining of Multiple QVDs

[craig157]

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

[jonathandienst]

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.

[Kushal_Chawda]

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

[craig157]

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

[craig157]

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

[afsarshaikh]

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!

[Kushal_Chawda]

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

[buzzy996]

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.

[Peter_Cammaert]

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?

[prieper]

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