Issue with Single Quotation Marks Being Replaced by Question Marks in Alteryx Workflow

Hello,

My Alteryx workflow for data mapping works in the following way:
Whenever I receive new values to be mapped from the source Excel file, those new values get written into a Redshift table as VARCHAR(255) to be mapped to the master value. Once they are mapped, they are used for subsequent mappings.

The issue is that all values containing single quotation marks are successfully saved into the table, but once they are exported to the Alteryx flow through the "Input Data" tool, all single quotation marks are replaced by question marks during the reading process.

Adding "Charset=UTF8" to the connection string didn't help resolve the issue.

I would appreciate it if someone could help me with resolving this.

Thank you.

Database Connection

Accepted answers

apathetichell

That explains alot - that driver is not really compatible with Alteryx. It use to give exactly 1 character when used with some models of Designer. Swap to the Alteryx SIMBA Amazon Redshift driver available through the download page - and try again.

https://help.alteryx.com/current/en/designer/data-sources/amazon-redshift.html

Max2466

Thank you a lot for helping.
I didn't install the driver you suggested because it requires a license, but your advice about changing drivers led me to try the Amazon Redshift driver (the first one listed in the screenshot) instead of the Amazon Redshift ODBC Driver I used before. This solved my issue.

All comments

danilang

Hi @Max2466

This could be a mismatch between the code page in your Redshift data and the code page in Alteryx. The single quotes are extended characters in a UTF-16 alphabet. When you read them back into Alteryx, the extended character info is lost.

Any chance you can post a screen shot?

Dan

Max2466

Hi Dan,

Thank you a lot for helping with this, and apologies for the late reply. I had no access to my device.

I've seen some screenshots showing the code page option in the Input Data Tool settings. But for me, it's missing. Do you have any idea why? I couldn't manage to find an answer myself.

This is the data type and encoding in the Redshift table the data comes from:

Capture 1.JPG

Please let me know if you need any specific screenshots to take a look.

Thank you,
Max

apathetichell

Max - can you share your odbc 64 settings? and turn on logging in your odbc 64? It's worth seeing if this is occuring in Alteryx or in the driver...

Max2466

Hello,

Thanks for taking a look at this.

Here you go -

Sorry if it's not what you have requested.

apathetichell

https://help.alteryx.com/current/en/designer/data-sources/amazon-redshift.html

Max2466

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335