Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unicode Matching Function

aakarsh_kalra
7 - Meteor
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
1 REPLY 1
aakarsh_kalra
7 - Meteor
Carlos from Alteryx helped me on this and suggested to use ConvertFromCodePage() function. Seems to worked for the use-cases I had.
Labels