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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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