Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
rajendras
Contributor III
Contributor III

Load Script

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

3 Replies
Not applicable

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.

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein