do not load data

avelasquezross — Thu, 01 Aug 2019 15:58:00 GMT

Hello Good morning, I'm new to Qlik Sense, I'm making an app that connects to my Oracle database, and I'm doing a join in the select, but the data doesn't load me.

Set dataManagerTables = '','BI_OPORTUNIDAD_PIPE_drive','TAL_HITO';

//This block renames script tables from non generated section which conflict with the names of managed tables

For each name in $(dataManagerTables)

Let index = 0;

Let currentName = name;

Let tableNumber = TableNumber(name);

Let matches = 0;

Do while not IsNull(tableNumber) or (index > 0 and matches > 0)

index = index + 1;

currentName = name & '-' & index;

tableNumber = TableNumber(currentName)

matches = Match('$(currentName)', $(dataManagerTables));

Loop

If index > 0 then

Rename Table '$(name)' to '$(currentName)';

EndIf;

Next;

Set dataManagerTables = ;

Unqualify *;

LIB CONNECT TO 'Oracle.us-west-2.compute.amazonaws.com'; // This connection is fine but for the sake of the information you don't write everything-

[REPORTES]:

Load

[COD_PROYECTO] AS [TAL_HITO.COD_PROYECTO],

[SERIAL_HITO] AS [TAL_HITO.SERIAL_HITO],

[COD_CONTRATO],

[ID_OPOPD],

[COD_PROYECTO],

[DES_HITO],

[FECHA_VENC],

[PRJ_DELTOTAL],

[MTOUF_HITO],

[COD_APROB_CLTE],

Date(Date#([FECHA_REALHITO], 'DD/MM/YY') ) AS [FECHA_REALHITO],

[COD_TIPOHITO],

[FECHA_FORMALIZA],

[FECHA_PAGOREAL],

[FECHA_GAF],

[ID_OPORTUNIDAD],

[DESCRIPCION],

[STATUS],

[OWNER_NAME],

[COD_ESTADO],

[FORMATTED_WEIGHTED_VALUE],

[FECHA_REGISTRO],

[WON_TIME],

[CLOSE_TIME],

[SERIAL_HITO];

SELECT NVL(h."COD_PROYECTO", p."OWNER_NAME") COD_PROYECTO,

NVL(TO_CHAR(h."SERIAL_HITO"), p."OWNER_NAME") SERIAL_HITO,

NVL(h."COD_CONTRATO", p."OWNER_NAME") COD_CONTRATO,

NVL(p."ID_OPOPD", p."OWNER_NAME") ID_OPOPD,

NVL(p."COD_PROYECTO", p."OWNER_NAME") COD_PROYECTO,

h."DES_HITO",

h."FECHA_VENC",

h."PRJ_DELTOTAL",

h."MTOUF_HITO",

h."COD_APROB_CLTE",

h."FECHA_REALHITO",

h."COD_TIPOHITO",

h."FECHA_FORMALIZA",

h."FECHA_PAGOREAL",

h."FECHA_GAF",

h."ID_OPORTUNIDAD",

p."DESCRIPCION",

p."STATUS",

p."OWNER_NAME",

p."COD_ESTADO",

p."FORMATTED_WEIGHTED_VALUE",

p."FECHA_REGISTRO",

p."WON_TIME",

p."CLOSE_TIME",

p."SERIAL_HITO"

from "ALIGARE_USER"."TAL_HITO" h , "ALIGARE_USER"."BI_OPORTUNIDAD_PIPE_drive" p

where

RTRIM(h.COD_PROYECTO) = p."COD_PROYECTO" (+);

Could you please help me, I am doing my engineering practice and, the company wants to know if they follow or not Qlik Sense.

regards

ANGE

Re: do not load data

treysmithdev — Thu, 15 Aug 2019 19:50:34 GMT

Are you sure the SQL query returns results? This would be the first thing I would test, preferably in your database tool ,not Qlik.

It may not make a difference but I would change "SELECT" to be "SQL SELECT".

One error I see is that you have two columns aliased to "COD_PROYECTO". You need to make the names unique within a table. Qlik will load the query output by column's name, not order. So at the moment I don't see how Qlik would know which column to use.

topic do not load data in App Development

do not load data

Re: do not load data