Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi please tell me how to do bulk loading
Regards
vishnu
You mean to say how to load large amount of data sets in Qlikview?
*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****
As per my knowledge there is no such option bulk load available in Qlikvew as of now ,
types of load
- In-Line
- Load from files (excels,db,xml, etc)
- Partial Load
- Incremental Load
- buffer load
Vikas
You can use the binary command to load all data from one QVW into another.
You are restricted to only one binary command in an application and it must be the first line of the script.
You can then load other data and / or manipulate the data after the binary command.
The best method for loading large data volumes is to use QVD files and an incremental load script.
Hi Vishnu,
you specified bulk load,how much amount of data you have? (Suppose 50 GB)
From where you are fetching the data?(is it Excel,Database...etc)
if possible split the data into some qvd's and fetch the data from that qvd's in script.
Try to avoid usage of Macro's in application
Try to reduce difficulty calculation in Expression level and do those calculations in script and fetch the data from columns directly.
if assumptions are wrong tell me the correct scenario of Bulk Loading .So that i will help to you.