Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script doubts -RESIDENT,rename ,drop

EMPTemp:
LOAD * INLINE [Ename,Employee_number
'A',1
'B',2
'C',3
'D',4
'E',5
'F',6
];

EMP_TBL:
LOAD
Ename,Employee_number  AS Emp_number
RESIDENT EMPTemp;

drop table EMPTemp;

Why should I drop EMPTemp?
Why should I rename Employee_number to other name Emp_number in EMP_TBL?
What RESIDENT will do?

I think forum gurus will share more things than product manuals.

Kindly explain.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

1) When you are loading Data from previously loaded table in QlikView Script, you should use Resident Load

2) If you not drop the EXPTemp, there are two tables in the data model associated (Linked) with Field Ename

3) If you don't rename the Field Employee_number to Emp_number, the two tables would be concatenated automatically as in QlikView Script, this tables having same field name and same number of columns...Also when you drop the First Table, the 2nd Table which is now a part of 1st table will also be dropped, so you don't have data in your data model..

Hope this will help

View solution in original post

4 Replies
MK_QSL
MVP
MVP

1) When you are loading Data from previously loaded table in QlikView Script, you should use Resident Load

2) If you not drop the EXPTemp, there are two tables in the data model associated (Linked) with Field Ename

3) If you don't rename the Field Employee_number to Emp_number, the two tables would be concatenated automatically as in QlikView Script, this tables having same field name and same number of columns...Also when you drop the First Table, the 2nd Table which is now a part of 1st table will also be dropped, so you don't have data in your data model..

Hope this will help

View solution in original post

ashfaq_haseeb

Hi,

Follow this

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ

sujeetsingh
Master III
Master III

Let there be two Tables as

Table1

OrderID

Shop

DeliveryDate

Status

Table2

OrderID

ProductID

DeliveryDate

Status

Quantity

Now if you load this two tables in script there will be three association key as OrderID,DeliveryDate and Status.

Now if You want to Join them only on OrderID then rename the DeliveryDate  and Status.

Resident load is also used to reuse already in-memory loaded tables.

Mainly this is been used in transformation, Calculation, using Qlikview functions with Select query etc

bill_markham

In this instance I would use a preceding load though.


EMP_TBL:

LOAD

Ename,Employee_number  AS Emp_number

;

LOAD * INLINE [Ename,Employee_number
'A',1
'B',2
'C',3
'D',4
'E',5
'F',6
];