Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
If you don't do any manipulations the you don't need the preceding LOAD. Just SQL Select ... From ... etc; will do fine.
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.