Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikBeginner1
Creator
Creator

Beginner - SQL LOAD in QVD

Hello! I am trying to do a sql load in a QVD with a where clause, I have done this before and it works however now its coming up with an error saying:

Connector reply error: SQL##f - SqlState: 42000, ErrorCode: 102, ErrorMsg: Incorrect syntax near 'Liability'.,

[TDWH_Coverage_S01]:
SQL SELECT [ID]
,[FD]
,[TD]
,[CoverageExpiryDate]
,[CoverageCancellationDate]
,[LineOfBusiness]
,[CoverageStatusCode]
,[CoverageStatusDescription]
,[CoverageSourceSystemCode]
,[CoverageSourceSystemName]
,[CoverageTypeCode]
,[CoverageTypeDescription]
,[PolicyNumber]
,[ConfCoverageTypeCode]
,[ConfCoverageTypeDesc]
,[PolicyHeader]
,[CoverageDeletedFlag]
,[CoverageEffectiveDate]
,[LegalEntity]
,[RUNNO_INSERT]
,[RUNNO_UPDATE]
FROM [GBQPS1SDA01DWHPOASL].[pol]."TDWH_Coverage_S01"

where YEAR(TD) = 9999 and CoverageTypeDescription= Employers Liability;

 

This is the code that is in the QVD which is now coming up with a incorrect syntax? the where clause for YEAR(TD) = 9999 is working, any help would be appreciated. 

Thanks Community in advance!

Labels (1)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

shouldnt there be quotes around the string value in where clause

CoverageTypeDescription= 'Employers Liability'