topic Re: Select vs Load in QlikView https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049257#M920600 <HTML><HEAD></HEAD><BODY><P>Select is used to load data from databases such as Oracle and can have LOAD in the preceding load. Within Select you can do transformation which are allowed within your database. QlikView's transformation won't work in Select if those are not supported by your database. The reason that this happens is because Select takes QlikView to the database end to get data and brings transformed data into QlikView.</P><P></P><P>Within Load is QlikView's transformation. You won't be able to perform your databases's transformation function within LOAD because this is QlikView's arena now.</P><P></P><P>Does that make sense?</P></BODY></HTML> Sat, 30 Apr 2016 18:09:22 GMT sunny_talwar 2016-04-30T18:09:22Z Select vs Load https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049256#M920599 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Is load only used when we want to use the functions of Qlikview like IF statements.</P><P></P><P>Please explain the difference between the two.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049256#M920599 2020-11-25T16:16:04Z Re: Select vs Load https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049257#M920600 <HTML><HEAD></HEAD><BODY><P>Select is used to load data from databases such as Oracle and can have LOAD in the preceding load. Within Select you can do transformation which are allowed within your database. QlikView's transformation won't work in Select if those are not supported by your database. The reason that this happens is because Select takes QlikView to the database end to get data and brings transformed data into QlikView.</P><P></P><P>Within Load is QlikView's transformation. You won't be able to perform your databases's transformation function within LOAD because this is QlikView's arena now.</P><P></P><P>Does that make sense?</P></BODY></HTML> Sat, 30 Apr 2016 18:09:22 GMT https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049257#M920600 sunny_talwar 2016-04-30T18:09:22Z Re: Select vs Load https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049258#M920601 <HTML><HEAD></HEAD><BODY><P>Very clear. Thank you sunny.</P></BODY></HTML> Sun, 01 May 2016 02:25:03 GMT https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049258#M920601 2016-05-01T02:25:03Z Re: Select vs Load https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049259#M920602 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>If you got what you were looking for, I would suggest closing this thread by marking correct answer.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Sun, 01 May 2016 16:30:42 GMT https://community.qlik.com/t5/QlikView/Select-vs-Load/m-p/1049259#M920602 sunny_talwar 2016-05-01T16:30:42Z