Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Resident load

Hi fnds,

I have a question in my mind that after every resident load do we need to drop that table from where we have extracted.

Sales_T:

Load * Inline [

TxnID,Amount

101,456454

102,456454

103,455446

104,456787

105,446464

106,458464

];

Sales:

Load * resident Sales_T;

Drop Table Sales_T;

In which case we should go for dropping the table.

9 Replies
Highlighted
vipin_mishra479
Contributor II

Re: Resident load

for in this case

if u not use drop table automatically data are double because its automatically concat  the both table.

there is two way to work on this

1 use no concatenation

2 drop table

Partner
Partner

Re: Resident load

Hi,

Whenever you will take the resident load then you have the same data in two tables.

these two tables will consume RAM.

hence to avoid the RAM consumption we need to drop the table.

-Nilesh

Not applicable

Re: Resident load

Thank you Nilesh and Vipin

Partner
Partner

Re: Resident load

Hi Deepthi,

In the above case, if you run the script, you will not get any data. It happens like this.

1. First table will be loaded.

2. The resident load table(2nd table) will get automatically concatenated to the first table as all the fields are same.

3. Now when you drop the first table, there will no tables in your data model.

So, now even you drop the table, the purpose is not getting served. Before using resident load, it is always advisable to use noconcatenate if all the fields are same.

The main reason behind dropping the original table is whatever data is required is already there in the second table.

Cheers,

Naresh

neetha_p
Honored Contributor

Re: Resident load

Apart from avoiding Ram consumption and concatenating of tables

Its Best practice to clean-up as you go, which avoids loading fields not used in visualization.

So list of field to select will be short and user friendly.

Not applicable

Re: Resident load

Yes Naresh.I got that now.But i took only two tables but in the middile i have same table columns of Sales_T with different data.There i need to do concatenation.but i took that two tables to show an example.But the example was wrong.I got the depth concept by ur reply.

Thank you & Regards,

Deepthi

alis2063
Contributor II

Re: Resident load

Dear Vipin ,

i have checked the same that it does not twice even  i did not drop the Main Table/(Drop Table Sales_T).

Please be sure if you are assisting someone about fundamental


Partner
Partner

Re: Resident load

Interesting....

Hi Ali

Can you post the QVW that you have used for this.

Kohli
Contributor II

Re: Resident load

Sales_T:

Load * Inline [

TxnID,Amount

101,456454

102,456454

103,455446

104,456787

105,446464

106,458464

];

Sales:

Load * resident Sales_T;

Drop Table Sales_T;

In above case we can't remove the Sale_T table. We have to remove the Sales(Parant) table. The Sales_T data will get from Sales table.