Alteryx Designer Desktop Discussions

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

Mix up letters within a phrase / word

bakaidora
8 - Asteroid

Hello Everyone,

 

I have a use case where I need to mix up the characters within a word / cell.

e.g.

apple -->paple

car --> rac

or something like this.

There is specific rule for the order of the letters, I simple just want to use all letters but in a different order.

Is it possible in Alteryx?

Thanks, Dóra

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @bakaidora 

 

One way of doing this is by splitting the word to letters, and then reorder it and create the word again. I did it here, i am reversing the word:

 

Felipe_Ribeir0_0-1674819657732.png

 

 

bakaidora
8 - Asteroid

@Felipe_Ribeir0Thank you. This is what I need. :)

BS_THE_ANALYST
14 - Magnetar

@bakaidora one way if you want to randomly shuffle the letters. Each time you run the workflow, the letters will shuffle again:

BS_THE_ANALYST_0-1674820537214.png

 

 

Felipe_Ribeir0
16 - Nebula

Good one @BS_THE_ANALYST !

Labels