Removed a extra semi colon. Try this:
LOAD [Entity Status],
[Original Eff Date],
[Policy Eff Date],
'A' as Entity_Status2,
if([Student Flag]='Y','STUD','PROF')as Studflag,
Floor((Interval(Today()-Date#([Original Eff Date],'YYYYMMDD'),'D'))/365) as Yrsins1
(ooxml, embedded labels)
WHERE [Entity Status]='A';
You already resolved my question, but I have a related issue. When I modify this script to directly read the data via an ODBC connection to a file that contains 6 million records, the load takes 60 minutes. If I do the same thing in an access database via an ODBC connection the load takes only 5 seconds. I can I access the data faster ?
The process is the same for both MS Access database and Qlikview document. The MS Access database is on my local C:\ drive and so is the Qlikview document. The data resides on a server in Chicago Illionois, my local desktop is in Philadelphia Pennsylvania. The ODBC connection in the MS Access database reads the data in 1 second, I can view all 6 million records in 1 second. The ODBC connection in Qlikview loads the records in 60 minutes.