Error displaying data from the connector

[07mishin]

Good day. 

I have Error displaying data from the connector ODBC.

Problem with encodings or connector?

Screenshots in attachment.

[Akshesh_Patel]

Hello,

The error needs to fix from the SQL side. please refer to this for possible solutions: https://sebhastian.com/mysql-error-1054-fix/#:~:text=The%20ERROR%201054%20in%20MySQL,UPDATE%20%2C%20....

Thanks

[Akshesh_Patel · Accepted solution]

Hi,

Please try to just insert the script in the data load editor and then comment on the field that is throwing the error and load the data without that field and see if any error there, that way we can narrow down the error to just a particular field.  Next, rename the field from SQL end or try renaming the script itself in Qlik. Load data again

Thanks

[Akshesh_Patel]

Hi,

Please try to just insert the script in the data load editor and then comment on the field that is throwing the error and load the data without that field and see if any error there, that way we can narrow down the error to just a particular field.  Next, rename the field from SQL end or try renaming the script itself in Qlik. Load data again

Thanks