Random sampling ensuring unique results based on one column

Hello,

Very new to Alteryx, and this site. Hoping someone might be able to assist with the below, please.

I'm looking to randomly sample from a population (excel file), but I need to ensure I don't sample the same group more than once from one particular column. I'm using the random % sampling tool, but there's no option to configure other than number of records.

Thanks

Help

Accepted answers

martinson

Hi @KyleC I am unaware of any way to do this within the sample tool. If there are duplicates, using the unique tool with the group selected will ensure a group only appears once in the sample.

I hope this helps, any other questions let me know.

martinson

Bulien

Screenshot 2025-01-15 160132.png

All comments

martinson

Hi @KyleC I am unaware of any way to do this within the sample tool. If there are duplicates, using the unique tool with the group selected will ensure a group only appears once in the sample.

I hope this helps, any other questions let me know.

martinson

Bulien

Screenshot 2025-01-15 160132.png

KyleC

Hi @martinson - thanks for the suggestion! I will give it a go and see how I get on.

martinson

@KyleC Unfortunately this will mean you cannot accurately predict the number of records in the sample. If you require an exact sample size I'd recommend using the random % sampling tool on a list of unique groups and then randomly selecting 1 record from each.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703