Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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

@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