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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is difference between select and load

What is difference between select and load

2 Replies
Not applicable
Author

I believe the biggest difference is that a SELECT statement retrieves from the database and the LOAD statement has to do with how it is loaded into QV's memory.  I am sure there is more to it.

datanibbler
Champion
Champion

Hi anil,

SELECT is used to draw data from a database.

LOAD is usually used to load from a qvd, from an Excel - anything except a database, actually

<=> You can, and should probably, use a LOAD on top of a SELECT when you load data from a database (because some functions might be available in QlikView which are not part of the SQL syntax and v.v.).

HTH

Best regards,

DataNibbler