SOLVED
Randomize field order
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JR1
7 - Meteor
‎06-16-2017
12:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Developer Tools
2 REPLIES 2
20 - Arcturus
‎06-16-2017
12:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎06-16-2017
12:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works great! Thank you very much!
