Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Unicode Matching Function

7 - Meteor

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?

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