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?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
