topic Re: preceding load in QlikView

preceding load

Wed, 05 Nov 2014 11:19:51 GMT

what is the difference between normal load(using odbc,xls,...) and preceding load?

Re: preceding load

amit_saini — Wed, 05 Nov 2014 11:22:37 GMT

Check below:

Benefit of using Preceding load ..

Thanks,
AS

Re: preceding load

Wed, 05 Nov 2014 11:32:04 GMT

example :

tablea:

products

apple

banana

orange

here if u load normally then u will get like

sql select * from tablea; ------ here u can't see what are data loading and can't comment also

if u use precedding load it loads like

load

apple

//banana --- here u can see what are data loading and if u want u can comment also

orange

from products;

Re: preceding load

Wed, 05 Nov 2014 11:39:29 GMT

Thank you amit

Re: preceding load

Peter_Cammaert — Wed, 05 Nov 2014 11:40:26 GMT

A preceding load is just a way of saving script content. You'll have less typing to do when using preceding loads. E.g. the following two constructs do exactly the same. The 2nd one uses a Preceding LOAD.

TempFacts:

LOAD *

FROM BigTable.qvd (qvd); // Very fast load

Facts:

NOCONCATENATE

LOAD PartNo, Date, Count, OrderID, Amount

RESIDENT TempFacts;

DROP Table TempFacts;

Facts:

LOAD PartNo, Date, Count, OrderID, Amount; // Executed LAST

LOAD * // Executed FIRST

FROM BigTable.qvd (qvd);

Internally, a Preceding LOAD uses resident tables just like the first example. You just won't notice.

Watch out however, because many times preceding loads behave erratically or produce illogical errors. I do try to avoid them because of many unexpected problems.

Re: preceding load

puttemans — Wed, 05 Nov 2014 11:44:40 GMT

The biggest difference is that a normal load goes out to where you want it, and fetches data there (outside Qlikview).

A preceding load only uses data that have already been loaded through a normal load before. Instead of then using the 'resident', you use the preceding load.

Re: preceding load

Wed, 05 Nov 2014 12:06:37 GMT

Thank you for the explanation

Re: preceding load

Wed, 05 Nov 2014 12:18:54 GMT

Hi,

preceeding load will help to do some transformations and we can work on qlikview functionality using the preceeding load.we can't use qlikview functions while fetching the data using odbc/oledb.