topic Re: preceding load in QlikView

preceding load

sunil1989 — Wed, 31 May 2017 10:46:51 GMT

Hi All,

Thanks in Advance!!!

Can someone help me in understanding preceding load , so i can implement.

Thanks,

Sunilkumar

Re: preceding load

Anil_Babu_Samineni — Wed, 31 May 2017 10:49:24 GMT

I assume, you will get bulk of threads while start search in Qlik Community. Can you check same. I would always start surf in Help forum only instead of here. Happy to go

Re: preceding load

sunny_talwar — Wed, 31 May 2017 10:52:27 GMT

What is the issue you are running into? Or is this in general question? May be look here:

Preceding Load

Re: preceding load

migueldelval — Wed, 31 May 2017 10:57:48 GMT

Hi Sunikumar,

In preceding Load you can make changes in your fields, for example:

a) Extract Month from a date: Month(date_field) as Month_field,

b) Make a flag: IF(field_value > 50, 1,0) as Flag_field_value,

c) Concat fields

d) Make Keys (autonumber)

e) Rename Fields

etc

But First check always "QlikView manual":

"The preceding LOAD feature allows you to load a table in one pass, but still define several successive transformations. Basically, it is a LOAD statement that loads from the LOAD or SELECT statement below, without specifying a source qualifier such as From or Resident that you would normally do. You can stack any number of LOAD statements this way. The statement at the bottom will be evaluated first, then the statement above, and so on until the top statement has been evaluated.

You can achieve the same result using Resident, but in most cases a preceding LOAD will be faster.

Another advantage of preceding load is that you can keep a calculation in one place, and reuse it in LOAD statements placed above."

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/preceding-load.htm

LOAD data into QlikView

Regards

Miguel del Valle