Random sampling ensuring unique results based on one column

[KyleC]

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

[martinson · Accepted solution]

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

[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.