topic what is bulk load in qlikview in QlikView

what is bulk load in qlikview

kashaboinaraj — Wed, 25 Nov 2020 16:16:04 GMT

Hi please tell me how to do bulk loading

Regards

vishnu

avinashelite — Mon, 01 Aug 2016 09:19:37 GMT

You mean to say how to load large amount of data sets in Qlikview?

vikasmahajan — Mon, 01 Aug 2016 09:23:01 GMT

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

Colin-Albert — Mon, 01 Aug 2016 09:27:41 GMT

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.

ramasaisaksoft — Mon, 01 Aug 2016 09:42:00 GMT

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.