topic Load Script in QlikView

Load Script

rajendras — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have selected tables from oracle data base using ODBC and it results SELECT statements in Qlikview. Next level I do not have any manipulations in the scripting level. Do I need really required Load Script or leave the SQL Script as it is with out writing "load" script.

Please suggest.

Thanks

Re: Load Script

Thu, 22 Dec 2016 09:39:40 GMT

If you need direct fields from oracle same as you follow is ok

suppose if you want to transform or derive by using those populated fields you need to get them by checking Preceding load option in create select statement window

then you can derive as per your requirement.

Re: Load Script

Gysbert_Wassenaar — Thu, 22 Dec 2016 09:40:17 GMT

If you don't do any manipulations the you don't need the preceding LOAD. Just SQL Select ... From ... etc; will do fine.

Re: Load Script

jonathandienst — Thu, 22 Dec 2016 09:44:14 GMT

Do you mean the preceding LOAD statement above the SQL statement? The LOAD statement is only required of you need to do some further manipulation of the data. Otherwise it is not required.