I have an interresting thing happening when I load a table (FACT_Temp) and left join another a table (STATUS). What I want to do is Resident Load a table (FACT) from FACT_Temp. The problem is it works perfectly when only the original fields from FACT_Temp are used. When I try to Resident Load it with the field added by the Left Join (from STATUS) the table (FACT) does not load. Anyone got an idea why that would be? I have attached a sample of what I mean.
I thought so too initially - that is why I put in the drop satement (for the temp table) but with the same result. I am going to log it with QlikTech support and see whether it is a bug. Will let you know!
Celambarasan is right. It is not a bug - it is a feature. QlikView concatenates the tables unless you have different sets of fields. The drop statement does not affect anything since it happens after the final load statement.
Use NoConcatenate or add a dummy field in the temp table, e.g.: 'dummy' as DummyField.