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.
LOAD data AS data1,
timestamp as datetime;
First 12 Load * Resident MyTable order by data1 asc, datetime asc;
Drop Table MyTable;