Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcushenriquesk
Creator
Creator

Translate SQL Query to be replicated on QVDS in Qlik Cloud Application

I originally created a query that is getting data through a NAT connection with an internal data base source. However, we made a move to use the Qlik Data Transfer Tool to load data into our qlik cloud environment instead. Using the Qlik Data Transfer Tool I have imported all the tables that are need to replicate the original query that created the data view. Here is the query, however, I am unsure how to translate it into a format that uses the QVDs within the environment. 

 

MinReceivedLocTable:
sql select LOCATIONS.LOC_ID ,TO_char(min(trunc(REQUISITIONS.RECEIVED_DATE)), 'MM/dd/yyyy') as RECEIVED_DATE_MIN
FROM ACUTIS.REQUISITIONS
INNER JOIN ACUTIS.REQ_PANELS ON REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID
INNER JOIN ACUTIS.LOCATIONS ON REQUISITIONS.LOC_ID = LOCATIONS.LOC_ID
where trunc(REQUISITIONS.RECEIVED_DATE) is not null
and REQUISITIONS.Del_flag = 'F'
group by LOCATIONS.LOC_ID;

 

I have the Requisitions and locations tables within the same space as the application in QVD format. How do I go about replicated this SQL query to return the same data table from the QVDs.

Labels (2)
0 Replies