Table creation in join -iteration

[#1]

Hi all

I have a QVW which should integrate data for many companies. Each company has a lot of data.

So there is a QVD per company.

I load data for company A.

Then I make a join on 2 tables of data for company A and store it in table X.

Then I load data for company B.

Then I make the same join for company B and store the output in table X.

At this point, I do not know why, Qlikview uses table X for company A and talbe X-1.

If I try the process for a third company (C), then Qlikview creates a table X-2.

Have you ever experienced the same? What is usually the cause of such behavior?

The problem is that when Qlikview ends the script, it is blocked and I can not access the datamodel : I should restart Qlikview. Though I do not have the opportunity to explore the outputs.

Thank you in advance.

Hub

[jonathandienst]

Hub

The data you are loading is not concatenating properly, and it is hanging at the end trying to construct some horrendous synthetic keys. It appears from your description if the tables from each company are not identical in structure.

To make sure that the tables concatenate, either make sure that all the company tables have the same fields, or use  "concatenate LOAD"  for all the loads after storing A.

Regards

Jonathan

[jonathandienst]

To test this, run the reload in the debugger, and select the Limited Load option and load 100 in each load statement. You wont be able to use the output, but you can see what it is doing and inspect the resulting data model.

Jonathan

[qlikpahadi07]

Your mapping is not Correct ...case for  X and X-1 means you are loading two different tables and one Table Name at top.

or if you are using Drop Statement  possible you are skipping some thing.

Debug your CODE/ or execute Step by Step  you will get to know

Simply When you store in table that is QVD just Drop the Table and confirm it with Cntr+T.

[jagan]

Hi,

Can you attach the sample script, so that it would be easy to analyse.

Regards,

Jagan.