community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Unicode Matching Function

Highlighted
Hi,

I noticed some inconsistent behavior while using DecompseUnicdoeForMatch() function. In my input excel files there are some foriegn characters which i want to get rid of, when i use that excel file as an input and set Code-Page to UTF-8 this function works absolutely fine and all the unwanted characters are removed.

However, when i input the same text via a redshift database, configured using ODBC (Postgres Unicode Driver) the function dosen't seem to work. It maybe that when data is coming from the db it's not formatted into UTF-8, any ideas on how to resolve or get around this?

Thanks,
Aakarsh
Carlos from Alteryx helped me on this and suggested to use ConvertFromCodePage() function. Seems to worked for the use-cases I had.
Labels