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

Masking Data using other Column Data

arjundelara
8 - Asteroid

Hi All,

 

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

 

 

3 REPLIES 3
ShankerV
17 - Castor

Hi @arjundelara 

 

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

TEXTJOIN("",1,MID(E2,SEQUENCE(LEN(E2),,LEN(E2),-1),1))

 

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

 

So can replicate the same in Alteryx.

 

Many thanks

Shanker V

mceleavey
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,

 

M.



Bulien

arjundelara
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!. 

Labels