We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Converting Latin characters

6 - Meteoroid

I have Portuguese source data containing Latin characters, in Excel files.  I want to convert these to characters in the basic Latin alaphabet, so they won't cause problems downstream in reports etc.


Examples: PortuµRios, Manipulação, Fia€ço


I've experimented with ConvertfromCodePage and ConverttoCodePage but didn't manage to get this result.  Is there a way I can do this in Alteryx without creating a set of substitution rules?  Or failing that, is there a reference available I could use to achieve this?



13 - Pulsar

There are some good ideas over here.  Take a look, see if one of these solutions works for you.

6 - Meteoroid

Perfect :)


This hadn't come up in my searches.