Random selection of records

Hi,

I am trying to obtain a random selection of 25 IDs and their corresponding records from a dataset. .

For reference, within my dataset, I have thousands of ID numbers, wherein each ID will appear multiple times given they have multiple records associated with the ID. I'd like to use one of the random sample tools within my workflow to select 25 of the IDs and return all of the records associated with the 25 IDs selected randomly.

I am very new to using Alteryx Designer, but I also may be overthinking this. Nonetheless, I can't seem to figure it out. Any knowledge or insight on how to accomplish will be greatly appreciated.

Thanks!

Help

Preparation

Accepted answers

cseputis

I figured this out. From my original dataset, created a separate flow using the Select, Unique, and Random % Sample tools, focusing on the ID to produce the random sample of 25 IDs. Then I used a Join at the end of my overall workflow to get the results I'm after.

All comments

IraWatt

Hey @cseputis,

Do you have an example dataset for context?

Thanks,

Ira

ChrisTX

Here's one way to do it

Chris

Random selection of records.yxmd

cseputis

Hi Ira,

Certainly a ton more IDs in my dataset, but here is a screenshot that may help.

Thanks,

Chuck

cseputis

ChrisTX

Nice solution. The workflow I posted is almost the same. I used a Formula tool to create a random number field, then sorted on the random number, then used a Sample tool to select the first 25.

Chris

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703