Hi team,
I have an Alteryx workflow. The input data (type: String) has an entry as 'Later (≥ 1 Year)'.
When Alteryx reads this, it converts it into 'Later (= 1 Year)'
Please, could you help with how to solve this?
Thank you, everyone, for the valuable suggestions.
The approach that solved this issue for me is checking this box -
My input is from an Oracle DB and I read somewhere that this could be the key and this indeed solve it. I am really not sure so far what this does behind the scenes.
Hi @svimal ,
this check box enables unicode support. Thus uncode characters in CHAR columns are extracted and transferred to Alteryx as WString or V_WString and not as String/V_String - that means, unicode characters are not corrupted in any way (basically, it's what @alexcordero and me said).
Best
Roland
REGEX_Replace([Field1], "≥", ">=") where Field1 is the field that contains your string. This would format it in the proper way if you need to do any math/sort/gouping in the workflow.
I think it's a character conversion issue. Try to set the code page to "Unicode UTF-8", it should be imported correctly then.
Best regards
It comes in as formatted as Later (≥ 1 Year) if you have the data type as V_WString or WString. These formats accept any character. String only accepts Latin-1 characters. ≥ is not in the Latin-1 character set. Then you can do your Regex conversion if still needed.
