About preceding load

[Kohli]

Hi Team. What is advantage of Preceding load option when we take the data from database?

[Anonymous]

The preceding load can be used to define multiple calculations and transformations within one load script. The preceding load takes input from a previous select statement. Preceding load is invoked by checking "preceding load" while selecting load statements. There is a direct option for preceding load when making the connectivity with ODBC or OLEDB.

[balar025]

Hi,

As per my analysis or experience, i can say best example or advantage is when we want to transform data up to some extend like

- Transpose of data,

- mapping values,

- changing format of data like month,year,quarter extraction from data,

- calculation of field like getting total amount from qty and unit cost..etc

- preparing composite primary key

- creating flag status

- Ravi Balar

[prma7799]

Please check this it might helpful

Benefit of using Preceding load ..

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