what is preceeding load....give me an examples

[#1]

what is preceeding load

[Anonymous]

The bold part is the preceding load in this simple example:

LOAD A, B, C;

SQL SELECT

A,B,C FROM Table;

[maxgro]

more detail here

http://www.quickintelligence.co.uk/preceding-load-qlikview/

[#4]

thank u

[MK_QSL]

https://community.qlikview.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load?author=2012/05

[Agis-Kalogiannis]

It is the LOAD statement you add ABOVE the SQL load statement, that will allow you to use internal QlikView functions, to be able to transform your data.

[vvvvvvizard]

besides the above valuable comments

its also mskes the code easier to read eg

without preceding load

load subfield(just imagine this is a very long formular) as firstname ,

another very long formular as surname,

very long formular & another very long form as fullname

with preciding load

an easier way is just type

load * ,

firstname & surname as fullname ;

load subfield(just imagaine this is very long ...) as firstname,

...... as surname

from (...) ;

[oknotsen]

If your question is answered, please flag the topic accordingly.

If not, please let us know what part of your question is still open.