topic Re: Temp table not dropping (Temp-1) in QlikView

Temp table not dropping (Temp-1)

Anonymous — Wed, 09 Oct 2013 13:25:05 GMT

Hello,

I am facing a weird phenomena.

Assume this scenario:

Script 1:

Temp:

Load * Inline [

];

T1:

Load * Inline [

A, C,

x, z,

y,k,

x, b,

];

Right Keep ('T1')

Load

Resident Temp;

Drop Table Temp;

The Output: T1 linked to Temp-1with T1 reduced in content to only x values.

Script 2

Temp:

Load * Inline [

];

T1:

Load * Inline [

A, C,

x, z,

y,k,

x, b,

];

Right Keep ('T1')

Temp1:

Load

Resident Temp;

Drop Tables Temp, Temp1;

The Output: T1 with T1 reduced in content to only x values.

Usually this doens't happen with me(or I don't notice it:) ), so can anyone share his insight?

Thanks,

Antoine

Re: Temp table not dropping (Temp-1)

CELAMBARASAN — Wed, 09 Oct 2013 13:40:47 GMT

I dont understand the issue?

You gave the example. But I couldn't get the issue your facing.

Re: Temp table not dropping (Temp-1)

Gysbert_Wassenaar — Wed, 09 Oct 2013 13:40:51 GMT

In the first script you don't specify a table name. Right Keep does keep the table, so it gets a name from Qlikview. Had you used right join instead you'd have only the reduced T1 left. This has the same effect as using right keep, giving the table the name Temp-1 and dropping Temp and Temp-1 at the end.

Re: Temp table not dropping (Temp-1)

Anonymous — Wed, 09 Oct 2013 13:50:12 GMT

I realise fully what you are telling me and it is correct. and makes sense...

thanks,

Antoine

Re: Temp table not dropping (Temp-1)

Anonymous — Wed, 09 Oct 2013 13:52:12 GMT

Well, Try copying the script and running the routine for both scenarios.

in the first one you will see a "new" table with a -1 index;

in the second one, you will not see it.

I thought that when I issue the drop table, the original table and the resident table get dropped. Which is not the case.

So actually, I better understand now how resident load work. it actually duplicates the table, and not simply creates a reference.

Re: Temp table not dropping (Temp-1)

swuehl — Wed, 09 Oct 2013 13:55:20 GMT

Just another note (if I understood correctly what you are trying to achieve):

You don't need a join / keep at all:

Temp:

Load * Inline [

];

T1:

Load * Inline [

A, C,

x, z,

y,k,

x, b,

] Where Exists(A);

Drop Table Temp;

Re: Temp table not dropping (Temp-1)

CELAMBARASAN — Wed, 09 Oct 2013 14:03:35 GMT

Why you don't use Left Keep for this case

Temp:

Load * Inline [

];

Left Keep(Temp)

T1:

Load * Inline [

A, C,

x, z,

y,k,

x, b,

];

Drop Table Temp;

Re: Temp table not dropping (Temp-1)

Anonymous — Wed, 09 Oct 2013 14:17:05 GMT

An even cleaner solution !

Thank you

Antoine

EDIT: mixed up with another post