topic Re: Resident Table does not shows in Table Viewer in QlikView

Resident Table does not shows in Table Viewer

Thu, 22 May 2014 03:48:22 GMT

Hi All,

I am new to qlikview.

I have store previous table in the Resident Table.

But, I am not seeing this Resident Table in the Table viewer.

is there any reason that it does not show in Table viewer ?

Any help would be appreciated.

Re: Resident Table does not shows in Table Viewer

simospa — Thu, 22 May 2014 04:25:09 GMT

Please attach the code or an exemple.

However, if you try:

Test1:

LOAD field1,

field2

FROM

[myTest.xls]

(ooxml, embedded labels, table is Sheet1);

Test2:

load * Resident Test1;

you'll see only Test1 table in Table Viewer because the two entity are identical.

So you can try this:

Test1:

LOAD field1,

field2

FROM

[myTest.xls]

(ooxml, embedded labels, table is Sheet1);

Test2:

load *, 'x' as fakeField Resident Test1;

drop field fakeField;

In this way you introduce a fake field and the two entity are different because of this new field.

If you want to keep only a table you have to add at the end the statement

drop table Test1;

Re: Resident Table does not shows in Table Viewer

Thu, 22 May 2014 04:26:42 GMT

paste your script here. Probably the structures are similar and it concatenated. If the structures are similar and you still want the new table to be created separately use the keyword "noconcatenate".

Re: Resident Table does not shows in Table Viewer

Anonymous — Thu, 22 May 2014 04:31:12 GMT

Hi Hailey,

Test2:

load * Resident Test1;

When your loading Load * resident table to another table Test it will concatenate both table and store result in Test1 as it create first. and Test2 won't exist any more.

1st if want both table you should use NoConcatenate before Test : Load * Resident Test1;

this will solve your problem.

But it will create synthetic table and key which generally not preferred good design.If you brief more what you actually want to I can help you better way.

Thanks & Regards

Kiran Kokade