Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.