I am trying to use a SQL prebuilt function in my SELECT statement but it errors out saying " not found". Do you know why this would be happening.
Script I am using is
FROM [ARSystem].[dbo].[table] (NOLOCK)
order by column1;
Am I missing any syntax?
Order by Column 1 is the mistake what i think qlikview didn't read column 1 please pass column name instead of column 1
I have used the column_name ... not column 1... Sorry to confuse you!
Sql keyword is missing.
ODBC CONNECT TO ....
you can check the syntax of the sql select with your db tool
if the db is sql server, sql server management studio
then, when you have a checked statement, copy it in qlikview and add load *;
Anbu is right SQL keyword is missing
I added SQL but did not work either!
order by colum_name;
Retrieving data ...