Issue with dumping data from SQL query

[#1]

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

[#2]

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.

[#3]

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.

[#4]

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.