Preceding load

[#1]

Hi all ,can any one explain how preceding load works ,and what is advantages of it with syntax,,

[MK_QSL]

Preceding Load is Load where no table name is given and instead it will use data just from the below table...

Load   

     *,

     Month(Date) as Month,

     Year(Date) as Year;

Load   

     Date

     Sales

From TableName:

Here below table will be loaded first

Load   

     Date

     Sales

From TableName:

Now

Load   

     *,

     Month(Date) as Month,

     Year(Date) as Year;

means, it will take all field from below table (*) and also, calculated Month and Year.

Preceding Load is used as it will give you better performance.

Update:

Check enclosed FIle

[#3]

Sorry am unable to get it ,,, can u please clarify

[MK_QSL]

===============================

\\Resident Load

Sales:

Load * Inline

[

  Date, Sales

  01/01/2014, 100

  02/02/2014, 120

  04/03/2014, 150

  15/04/2014, 200

];

Calendar:

Load Date,

  Month(Date) as Month,

  Year(Date) as Year

Resident Sales;

============================

//Preceding Load

Sales:

Load

  *,

  Month(Date) as Month,

  Year(Date) as Year;

Load * Inline

[

  Date, Sales

  01/01/2014, 100

  02/02/2014, 120

  04/03/2014, 150

  15/04/2014, 200

];

Check above example,

Two types of load is given

     1) Resident Load

     2) Preceding Load

In Resident Load you are using previously loaded table

In Preceding Load you are using table loaded just below your functions such as Month(), Year()...No Need to give table name as it will take data from table just loaded below...

For further clarification, try to use the link provided from the enclosed file from my previous reply

[#5]

Ok ,in resident load we give key as "resident" what about Preceding load ,,, with out key word its work ,please clarify

[SunilChauhan]

preceeding load is load followed by sql satement

if you connect sql db then it will ask you option preceeding load to check .

if you not check

then

it will load like below

Load *;

sql select

a,

b,

c

from owner.tablename

but if you check it you see

Load

a,

b,

c,

sql sect

a,

b,

c

from owner.tablename;

here one advantage of preceeding load is

you can calculate onother field from fields  and again other field from calculated field

using multiple load statement

See

Load *,

if(Flag=1,'Yes','No')  as Flag1

Load *,

if(a>0,1,0) as Flag;

Load

a,

b

c

from path

hope this helps

[MK_QSL]

Load

  *,

  Month(Date) as Month,

  Year(Date) as Year

From BelowTable;

Data used from BelowTable and in Preceding Load, we don't have to mention this...

[SunilChauhan]

seach for "preceeding load in qlikview" in google

you will find many more to learn

[#9]

go through these links

http://www.learnallbi.com/preceding-load-in-qlikview/

http://www.learnqlickview.com/the-power-of-preceding-load/

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

http://community.qlik.com/thread/87749

[jagan]

Hi,

There is no need of Precedent keyword, it is the technique,  Refer link in attached file for detailed explanation.

Regards,

Jagan.