Using two select statement in the data laod

[#1]

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.

[vinieme12]

what is the error?

also post your SQL statement

[#3]

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')

[avinashelite]

Could you share the complete load script statements

[avinashelite]

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?

[#6]

That's how it is on my script with only a few field names removed to shorten the code.

[#7]

there is a field name before that line called TICKET_ID and a function CONCAT before the link.

[sdmech81]

Have u put SQL statement before select??

[#9]

Nope. After the connector string, then my SELECT statement.

[avinashelite]

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