Select Statement does not work in SQL Select (scipt)
I am trying to import data from a SQL server using OLE DB, as the access is shared in form of datacube.
Managed to reach the point where i have successfully created a connection, but when I try to import data in script Editor, query fails. I looked up a lot of videos and realized in SQL SELECT part, the "SELECT" is not showing in blue, like part of the statement. I am attaching screenshot of the basic script.
If anyone has any leads, i would really appreciate.
I am using Qliksense Desktop June 2019 release.
PS: I also have access to Enterprise edition of Qliksense, it does not even allow me to see the database. But that is a different topic.