topic RESIDENT Load not working in QlikView

RESIDENT Load not working

wandapec — Sat, 24 Jul 2010 14:50:49 GMT

Hi Everyone,

I am at my wits end and have no idea what is going on. For some reason RESIDENT load of a previously loaded table is not working in my Qlikview. I have uninstalled and installed the latest version and still the same! It doesn't work in a new QVW or old... Here is a really simple script that didn't work. Is there a setting somewhere that I might have changed? For some reason Qlikview seems to load the data from the Temp table back into itself? Please help?

DataTemp:

LOAD * INLINE [

Name,Place,Age

Steve, Here, 23

Mike, There, 34

Alan, Here, 45

Gordon, Here, 56

Richard, There, 34

Jandre, Where, 56

];

People:

LOAD Name,Place,Age

RESIDENT DataTemp;

Drop table DataTemp;

RESIDENT Load not working

suniljain — Sat, 24 Jul 2010 15:25:31 GMT

This work fine for you.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

DataTemp:

LOAD * INLINE [

Name,Place,Age

Steve, Here, 23

Mike, There, 34

Alan, Here, 45

Gordon, Here, 56

Richard, There, 34

Jandre, Where, 56

];

People:

LOAD Name as T_Name,Place as T_Place,Age as T_Age

RESIDENT DataTemp;

Drop table DataTemp;

RESIDENT Load not working

Oleg_Troyansky — Sat, 24 Jul 2010 16:04:03 GMT

Steve,

this is a classic case of automatic CONCATENATION. Since your second load consists of exactly the same fields as the first, QlkView automatically concatenates the data into the first table. After the second load, you are left with 12 rows in DataTemp and no "People". Then you drop DataTemp, and you are left with nothing.

To prevent automatic concatenation, use keyword NOCONCATENATE in front of the load:

NOCONCATENATE LOAD * RESIDENT Tab1;

cheers,

RESIDENT Load not working

wandapec — Tue, 27 Jul 2010 14:07:15 GMT

Thanks for your help guys. Funny, I have been working on Qlikview for 4 years now and have never come across that problem.

Anyway, thanks again.

Steve