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

Randomize field order

JR1
7 - Meteor

This is a rather simple question, yet I am stumped on how it can be achieved.

 

I have a finalized list of items, and I want to shuffle them so that they are all in a random order.

 

Before Randomization

Field  1
1
2
3
4
5

 

After Randomization

Field 1
2
4
1
5
3

 

What is the simplest way to go about producing this output?

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

I like this approach:

 

In the formula tool, create a field with a DOUBLE type, let's call it SortOrder with the following formula:

Rand()

Now let's sort the data on SortOrder (ascending or descending).

 

The data will sort differently on each run.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
JR1
7 - Meteor

Works great!  Thank you very much!

Labels
Top Solution Authors