Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to Select top 12 without selecting all fields in SQL, load it, and then do a final load like below?
My purpose is to lessen the load on Qliksense by selecting less data from SQL before loading to Qliksense.
[MyTable]: LOAD data AS data1, timestamp as datetime; SELECT `data`, `timestamp`, FROM myDB.`myTable`; Final: NoConcatenate First 12 Load * Resident MyTable order by data1 asc, datetime asc; Drop Table MyTable;
I feel this issue resolved, Hence please close the ticket. Or else, Do you have any semicolon before resident table? Could you please post full script?