Hello, I'm load'g data from a txt file where some fields may have apostrophe (Emily's Place) or dashes or even slashes (/ \). The data is valid. There are cases when a record is read where 3 of the fields have special characters - I'm using a select tool to change the format to write into an oracle database. The surprising then is the 1st field containing some data is converted and written correctly; however, the subsequent fields containing the special characters recv error : could not fully converted from a WString to a String.
The input tool is already configured to use code page UTF-8
How to resolve using Alteryx?
Here's a simple workflow sample:
