Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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".
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