What is the error you are getting?
First thing to note is that your SQL needs to be preceded by the SQL command in Qlik Sense to be able to run, for example:
select ITEM AS Code,
NMPIAN AS Number
from Articles where Category='WIP';
Have you created a new Data connection to the Data Source?
Hi Gio - I assume you mean for Qlik Sense? If so this is because -Standard Mode - which uses a different approach for access data on file systems. (connection names) There is no need to use the drive letter - you need to create a folder connection first and then reference the folder connection name:
Your script should look like this.
The help document is located here:
If you want to use the statement the way it was used in QlikView - using the drive letter and directory path - you must disable standard mode:
Let us know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
BTW - as an example - this is the correct script generated by the Connection / Data Select wizard when accessing a SQL data source.:
LIB CONNECT TO 'localhost';
SQL SELECT ProductID,
myfile.txt 217 bytes