Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using two select statement in the data laod

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

31 Replies
vinieme12
Champion III
Champion III

what is the error?

also post your SQL statement

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

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?

Not applicable
Author

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

Not applicable
Author

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

sdmech81
Specialist
Specialist

Have u put SQL statement before select??

Not applicable
Author

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