Qlikview Freezes and Eats Mem on Join

[JustinDallas]

Hello Everyone,

So a little synopsis of the problem that I am trying to solve.  I am trying to say "

Load the table Fact into the table StupidFact.

Drop the Fact table.

Left Join the ShipTo table to the StupidFact table.

Drop the ShipTo table.

I have NOCONCATENATE because the StupidFact table won't be created since it has the exact same columns as the Fact table.  I'm dropping the ShipTo table for similar reasons.

Problem:

When I run the following script

StupidFact:
noconcatenate
LOAD *
RESIDENT Fact
;
DROP Table Fact
;
Left Join (StupidFact)
LOAD  *
RESIDENT ShipTo
;
DROP Table ShipTo
;

I notice that the Qlikview loading timer stops, and my application freezes forcing me to kill it with the Windows TaskManager.  Also, when looking at the output while it is loading, I've noticed it is creating another table (StupidFact-1) which I don't want to do.  I've attached a snapshot. 

Does anyone know what I am doing wrong when I am trying to create a new table called StupidFact which is the Join between the Fact table and the ShipTo table?

Any help is greatly appreciated.

[jagan]

Hi,

I think the issues there is no common fields in those tables.  Qlikview Joins the tables based on the column names.  Check whether there are common column names in that tables.

If there is no common fields this will become crossjoin or Cartesian product, so that's why it is taking more time.

Regards,

Jagan.

[ashfaq_haseeb]

Hi,

Apart from what jagan had suggested.

If you have more then 1 joining field try to create composite key instead.

Regards

ASHFAQ