topic Re: About preceding load in QlikView https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345108#M827165 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: 'open sans', sans-serif; font-size: 14px;">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. </SPAN></P></BODY></HTML> Fri, 07 Jul 2017 05:57:48 GMT Anonymous 2017-07-07T05:57:48Z About preceding load https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345107#M827164 <HTML><HEAD></HEAD><BODY><P>Hi Team. What is advantage of Preceding load option when we take the data from database?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345107#M827164 Kohli 2020-11-25T16:16:04Z Re: About preceding load https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345108#M827165 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: 'open sans', sans-serif; font-size: 14px;">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. </SPAN></P></BODY></HTML> Fri, 07 Jul 2017 05:57:48 GMT https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345108#M827165 Anonymous 2017-07-07T05:57:48Z Re: About preceding load https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345109#M827166 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As per my analysis or experience, i can say best example or advantage is when we want to <SPAN style="font-size: 13.3333px;">transform data up to some extend like</SPAN> </P><P>- Transpose of data, </P><P>- mapping values, </P><P>- changing format of data like month,year,quarter extraction from data,</P><P>- calculation of field like getting total amount from qty and unit cost..etc</P><P>- preparing composite primary key</P><P>- creating flag status</P><P></P><P>- Ravi Balar</P></BODY></HTML> Fri, 07 Jul 2017 06:01:51 GMT https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345109#M827166 balar025 2017-07-07T06:01:51Z Re: About preceding load https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345110#M827167 <HTML><HEAD></HEAD><BODY><P>Please check this it might helpful</P><P></P><P><A href="https://community.qlik.com/thread/87749">Benefit of using Preceding load ..</A></P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/preceding-load.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/preceding-load.htm">http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/preceding-load.htm</A></P></BODY></HTML> Fri, 07 Jul 2017 06:25:19 GMT https://community.qlik.com/t5/QlikView/About-preceding-load/m-p/1345110#M827167 prma7799 2017-07-07T06:25:19Z