The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Sampling

Status: Implemented Submitted by on ‎05-17-2018 10:45 AM
4 Comments (4 New)

Create the ability to randomly sample X number of records. For example, randomly select 16 samples from a data set.

See more ideas labeled with:
4 Comments
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎05-18-2018 05:24 AM

Maybe this is better suited for an idea for the product?

 

Solution:

 

Create a variable in a formula as:

RAND()

Sort your data by RAND() ascending and then sample N records from it.

 

Cheers,

Mark

0 Likes
Nate1
8 - Asteroid
‎05-18-2018 11:23 AM

If I understand this request this already exist. It's just hidden in the "Random % Sample" Tool.

 

random_sample.JPG

0 Likes
nmatt002
5 - Atom
‎05-18-2018 11:28 AM

Thanks for your response - I am new to Alteryx, and I didn't realize that was an option. Thanks for your help!

0 Likes
KylieF
Alteryx Community Team
Alteryx Community Team
‎11-01-2019 01:12 PM
Status changed to: Implemented

Updating this idea to Implemented as the tool Random % Sample is available under our Preparation category!

0 Likes
Labels