Some Unicode characters are not convertable by Alteryx workflow

[kmoon]

Hi,

Recently I went through an experience where despite using the function TitleCase(DecomposeUnicodeForMatch([_CurrentField_])), some unicode characters are not passed through the workflow and write to database. One of the column field had value of K’collon. Alteryx didn't recognize this character and truncated all the value after this character. I see only the value K in the database table. This special character is typed by Alt+0146. The symbol is well observed in Excel.

Can Alteryx provide any mean to recognize this character and pass all the string after this special symbol to database?

Your response would be appreciated.

Thanks.

[kmoon]

Hi @JohnJPS,

I use version 11.0 where I see only the option V_WSTRING (Forced). No option for V_STRING (FORCED).
When the previous excel file is uploaded, the data type never changed. Recent file is causing the data type to change it automatically.
Can Alteryx do anything about it?

Thanks.

[kmoon · Accepted solution]

Hi @JohnJPS ,

It worked. Forcing the data type to V_WSTRING (Forced) did the trick.

For a weird reason, I was unable to see the option yesterday.

Thanks.