Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to query same database but different tables using SQL language with two SELECT statement from the data load editor but it keeps giving me error. But my query separately when tested on my SQL developer?? Does qlik sense not allow using more than one Table.
Hi Raul,
Thanks for replying. I have resolved it, the editor for some reason did not want me to use SELECT *, I had to specify the fields I needed.
what is the error?
also post your SQL statement
Its a connector error problem.
Cant find the Attach button for a document, but the below is my script:
SELECT *
FROM ARADMIN."VOC_FEEDBACK_V2_VIEW"
WHERE CREATE_DATE > 18000 AND YEAR > 2016
AND CATEGORY in(
'ARCHIVE QUICK CHECK',
'CLINICAL DATA VISIBILITY TOOL',
'CLIN PHARM MODELING SIMULATION ANALYSIS WORKFLOW',
'CPMS AW',
'DATASET MANAGER',
'EDX - ELECTRONIC DOC EXCHANGE',
'ENAVIGATOR',
'GSP - GSK STUDY PORTAL',
'HARP',
'HARP SUITE',
'HIF - HEALTHCARE INFO FACTORY',
'HEALTHCARE INFO FACTORY VISUALISATION',
'INET CATALIST',
'INSIGHT (STUDY MANAGER)',
'PREDICTIVE MODELLING',
'PREDICTIVE MODELLING ENVIRONMENT (PME)',
'RBM - RISK BASED MONITORING',
'SITE OPTIMIZER',
'SPECTRE',
'STUDY ALLOCATION AND RESOURCING SYSTEM (STARS)',
'STUDY OPTIMIZER',
'SUPPLIER CONTRACTS',
'TSCG - TIBCO SPOTFIRE CLINICAL GRAPHICS',
'TRANSFER OF OBLIGATIONS')
AND RA in ('RD-IT-SUPPORT-SATYAM',
'IT-RDIT-SUPPORT',
'RD-IT-SUPPORT-WIPRO',
'List of RAs');
SELECT TICKET_ID_
,concat('https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?ticket_id=',TICKET_ID_) as Ticket_Link
,SUB_CODE
,OPENING_TYPE
,OPENING_CATEGORY
,OPENING_SUB_CODE
,PRIORITY AS Priority_Number
FROM INCIDENT_MANAGEMENT
where to_date(ARADMIN.get_rem_date(CREATE_TIME), 'Month DD, YYYY HH:MI:SSAM') > to_date('01/01/2016', 'MM/DD/YYYY')
and to_date(ARADMIN.get_rem_date(CREATE_TIME), 'Month DD, YYYY HH:MI:SSAM') < to_date('01/01/2018', 'MM/DD/YYYY')
AND (ASSIGNED_TO_GROUP_ = 'RD-IT-SUPPORT-SATYAM' OR ASSIGNED_TO_GROUP_ = 'IT-RDIT-SUPPORT' OR ASSIGNED_TO_GROUP_ = 'RD-IT-SUPPORT-WIPRO')
AND CATEGORY in(
'ARCHIVE QUICK CHECK',
'CLINICAL DATA VISIBILITY TOOL',
'CLIN PHARM MODELING SIMULATION ANALYSIS WORKFLOW',
'CPMS AW',
'DATASET MANAGER',
'EDX - ELECTRONIC DOC EXCHANGE',
'ENAVIGATOR',
'GSP - GSK STUDY PORTAL',
'HARP',
'HARP SUITE',
'HIF - HEALTHCARE INFO FACTORY',
'HEALTHCARE INFO FACTORY VISUALISATION',
'INET CATALIST',
'INSIGHT (STUDY MANAGER)',
'PREDICTIVE MODELLING',
'PREDICTIVE MODELLING ENVIRONMENT (PME)',
'RBM - RISK BASED MONITORING',
'SITE OPTIMIZER',
'SPECTRE',
'STUDY ALLOCATION AND RESOURCING SYSTEM (STARS)',
'STUDY OPTIMIZER',
'SUPPLIER CONTRACTS',
'TSCG - TIBCO SPOTFIRE CLINICAL GRAPHICS',
'TRANSFER OF OBLIGATIONS')
Could you share the complete load script statements
are you able to select the 'https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?ticket_id=',TICKET_ID_) from QV ? does it has access for QS?
That's how it is on my script with only a few field names removed to shorten the code.
there is a field name before that line called TICKET_ID and a function CONCAT before the link.
Have u put SQL statement before select??
Nope. After the connector string, then my SELECT statement.
Try like this
*Run the above complete query in your DB
*If it runs success then 'https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?ticket_id=',TICKET_ID_
try to load the data separately from this link
I feel your DB is not able to fetch the data from the above link , the statements after SELECT * will execute first in DB and then it returns to QS so issue is not with QS
Hope this helps you