Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

Alteryx Designer Desktop Discussions

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

Masking Data using other Column Data

8 - Asteroid

Hi All,


How to convert this formula in excel to formula in alteryx to masked the data. see the attached workflow



17 - Castor

Hi @arjundelara 


I am trying to crack this. Struck up in the breaking down this.



Can you please put in lay man terms what the above is doing. 


So can replicate the same in Alteryx.


Many thanks

Shanker V

17 - Castor
17 - Castor

Hi @arjundelara ,


interesting one and a great use of the reversestring() function in Alteryx.

You can achieve this by using the following formula:


right([Employee ID],1)+reversestring([Employee ID])+left([Employee ID],1)



This takes the last character of the string and applies it to the front of the original text. It reverses the original text and adds the first character of the original to the end.


I've attached the workflow.

I hope this helps,




8 - Asteroid

Hi @mceleavey ,


This is the formula I need!. Thank you so much. The formula I created is to get the data one by one from last to first so it is not dynamic when there's additional string in the data. I appreciate your time to solved this.



Thank you so much!.