In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

 

 

All the best,
BS

LinkedIN

Bulien
Felipe_Ribeir0
16 - Nebula

Good one @BS_THE_ANALYST !

Labels
Top Solution Authors