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
