topic Issue with dumping data from SQL query in QlikView

Issue with dumping data from SQL query

Wed, 22 Jun 2011 14:48:05 GMT

I've having a very weird issue where QlikView things it has dumped values into a table, yet the table contains zero rows. This table (Inventory) is what all my gauges/charts use so it is vital.

Here is the reload script:

Yet here is my table view:

Appreciate any help,

Kurtis

Issue with dumping data from SQL query

Thu, 23 Jun 2011 00:53:55 GMT

Could you post a sample of your app please? My guess is the synthetic key is what is killing your table but is hard to tell from what I can see here.

Issue with dumping data from SQL query

Thu, 23 Jun 2011 15:12:53 GMT

I can't let anyone use it as it connects to a company network of ODS's. The same code works for a couple ODS's, and refuses to load for others. I want to just say there's bad data, but my TempInventory table is full of data, QlikView says it dropped it into Inventory table, but it just doesn't.

Issue with dumping data from SQL query

Thu, 23 Jun 2011 17:53:22 GMT

Ok so in your script don't drop the temp table and see what is getting populated in there. Qualify everything so you can see exactly what table is filled with what. Also, take a close look at any synthetic keys that are being generated & eliminate them if at all possible. My guess is that there is some funky data that is causing the synthetic keys to mess up the load in the inventory table.