topic Its a question from a beginner's end in QlikView

Its a question from a beginner's end

Thu, 21 Apr 2011 06:26:13 GMT

Why we need to drop table inside a script and "Resident Load" where there are several procedure to comment?

I am new here.....So if possible post a detailed explanation.

Thanks & Regards,

Koushik.

SV:Its a question from a beginner's end

ToniKautto — Thu, 21 Apr 2011 08:17:04 GMT

The usage of these features depend on you are attempting to do with your loaded data.

Drop Table is used to delete table from your data model.

Resident Load is used to load data from an existing table into a new table.

Maybe some of QlikView's free online training session can be helpful for you to understand the principles further;
http://dev.qlik.com/us/services/training/free-training.aspx

SV:Its a question from a beginner's end

Thu, 21 Apr 2011 08:20:35 GMT

Thank you Toni.

I will try the link provided by you.

SV:Its a question from a beginner's end

Thu, 21 Apr 2011 08:24:59 GMT

After making use of the Resident QVD we can drop it because already we are using desired field in other table by making resident.

That will take space in our script and will create Synthetic Key as well to make our data model improper.

QV Rocks

SV:Its a question from a beginner's end

Thu, 21 Apr 2011 08:36:00 GMT

Yes ,Now its clear to me.

Thanks QV Rocks