Can you please let me know what is the difference between a SQL Select .... and Load statement in qlikview script editor?
I used to think, whenever you fetch data from a database you do SQL Select * from table and when you want to get data from a file such as excel or flat file you use Load * from Filename.
Am I right or wrong? or above all am I missing a whole point. Can anyone suggest what's the good practice about them.
I was wondering about why QlikView has put "Preceding Load" checkbox on Create Select Statement dialog. And most QlikView documents are using it when they're scripting. Your explanation, mby, made it more reasonable for me.
