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

Make a list with sort group by an id

Anastasio_Theohari
8 - Asteroid

Hello everyone,

 

 

I have this case,

 

id            status

3            dog;cat;frog

3            cat;dog;frog

3            dog;cat;frog

4            cat;shark

 

how can i make id=3 have the same sort?

 

The desire result will be like this:

 

id            status

3            cat;dog;frog

3            cat;dog;frog

3            cat;dog;frog

4            cat;shark

 

Any idea how can i implement this?

 

Thank you

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Anastasio_Theohari 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644484662002.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@Anastasio_Theohari Similar to @atcodedog05 approach but using RegEx tool

 

binuacs_0-1644486957672.png

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Anastasio_Theohari 

Cheers and have a nice day!

Labels
Top Solution Authors