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: 
Not applicable

Script Error: Cannot resolve the collation conflict

I'm getting the following script error: "ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

The bit of script itself is fairly straight forward:


SQL SELECT DISTINCT *
FROM Table2
WHERE EXISTS
(SELECT * FROM Table1 WHERE Table2.Field1 = Table1.Field1
AND Table2.Field2 = Table1.Field2)


I'm stumped. Has anyone run into this and have any recommendations?



1 Reply
prieper
Master II
Master II

Looks as if you have mixed the SQL-part with the QV-script-part.

You may have the SQL-syntax preceded with the QV-owned LOAD, like:

LOAD * WHERE EXISTS(YourField); SQL SELECT .... [here your SQL-statement];


Though the SQL will be performed and then further restricted/manipulated as per the preceding load.

HTH
Peter