topic Re: Re: Preceding load in QlikView

Preceding load

Wed, 30 Apr 2014 08:01:54 GMT

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

Re: Preceding load

MK_QSL — Wed, 30 Apr 2014 08:09:31 GMT

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

Re: Preceding load

Wed, 30 Apr 2014 08:16:59 GMT

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

Re: Preceding load

MK_QSL — Wed, 30 Apr 2014 08:25:15 GMT

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

\\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

Re: Preceding load

Wed, 30 Apr 2014 08:31:48 GMT

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

Re: Preceding load

SunilChauhan — Wed, 30 Apr 2014 08:36:00 GMT

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

from owner.tablename

but if you check it you see

Load

sql sect

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

from path

hope this helps

Re: Preceding load

MK_QSL — Wed, 30 Apr 2014 08:36:34 GMT

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...

Re: Preceding load

SunilChauhan — Wed, 30 Apr 2014 08:40:06 GMT

seach for "preceeding load in qlikview" in google

you will find many more to learn

Re: Preceding load

Wed, 30 Apr 2014 08:54:59 GMT

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

Re: Re: Preceding load

jagan — Wed, 30 Apr 2014 09:03:47 GMT

Hi,

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

Regards,

Jagan.

Re: Preceding load

Anonymous — Wed, 30 Apr 2014 09:20:48 GMT

Yep, and especially comes in handy when doing transformations upon transformations on fields. It will in a lot of cases save you from having to do tmp tables and drop statements, and it will save you from very long nested transforming statements.

Re: Preceding load

Wed, 30 Apr 2014 12:31:13 GMT

Ok,thanks

Re: Preceding load

Mon, 09 Jun 2014 10:44:39 GMT

LOAD ProductKey,

OrderDateKey,

year( DueDateKey) as Yeardue,

TotalProductCost,

sum(SalesAmount) as Totalsales,

SQL SELECT *

FROM AdventureWorksDW.dbo.FactInternetSales;

without unchecking preceding load iam getin same result so please eplain,,

Re: Preceding load

stevedark — Wed, 23 Jul 2014 21:44:16 GMT

Hi there,

You may want to see this blog post on the use of Preceding Load: http://bit.ly/1pHv56x

Steve