Some Unicode characters are not convertable by Alteryx workflow
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Bug
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.

- « Previous
- Next »