Load table field from oracle function

sgallego — Thu, 14 Sep 2017 07:25:40 GMT

Hi! I am new to Qlik Sense and I am trying to load a table field in a connection script from an Oracle DB (using Qlik ODBC connector Package with Oracle Driver) from the results of an Oracle function.

I can retrieve the table fields with the load script, and then I would like to fill a new field based upon the results of an Oracle function resident in the database package, using one of the table fields as a parameter.

I know that I could replicate that function in Qlik Sense, but I have lots of functions developed in the package and I'm trying to save all that work...

The load script is something like this:

LIB CONNECT TO 'Oracle_connector1';

LOAD CITYID,

ORDERID,

REFTIPO_RED;

[WORK_ORDER]:

SELECT "CITYID",

"ORDERID",

"REFTIPO_RED"

FROM "MIRA"."WORK_ORDER";

and now I want to load a new field (ex: REFTIPO1) using an Oracle function called MIRA.NIVEL_RED(REFTIPO_RED) wich retrieves the result with the previously loaded field REFTIPO_RED as a input parameter.

I've tryed using this formula after the table load:

Load REFTIPO1;

SQL MIRA.NIVEL_RED(REFTIPO_RED) as "REFTIPO1";

but I obtain the following error:

Field 'REFTIPO1' not found

Is it possible to load data in this way with Qlik Sense??

Thanks a lot in advance.

topic Load table field from oracle function in Connectivity & Data Prep

Load table field from oracle function