preceding load

[#1]

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

[amit_saini]

Check below:

Benefit of using Preceding load ..

Thanks,
AS

[#3]

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;

[#4]

Thank you amit

[Peter_Cammaert]

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.

1.

TempFacts:

LOAD *

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

Facts:

NOCONCATENATE

LOAD PartNo, Date, Count, OrderID, Amount

RESIDENT TempFacts;

DROP Table TempFacts;

2.

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.

[puttemans]

Hi

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.

[#7]

Thank you for the explanation

[#8]

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.