Random sampling but taking into consideration multiple fields

Hi there,

I am looking to sample based on a unique field but don't want to sample a person more than once. I hope that makes sense but I have put a basic example of the data I am working with below. E.g. I want to randomly select/sample 3 rows but do not want to sample a name more than once. So if in the random sample AB345 Alex was selected/sampled, then no more Alex's should be part of the sample. There should be three unique names in the sample.

I have tried a few things but unfortunately cannot get to the answer - would appreciate the help please.

UNIQUE FIELD	NAME
AB345	Alex
GF458	Brad
DC367	Charlie
VG689	Dave
FG234	Ethan
AV001	Charlie
YT534	Brad
FE123	Dave
LF823	Dave
PF287	Alex
RT987	Charlie
LL433	Dave

Best Practices

Accepted answers

Emil_Kos

Hi @JP_1,

Yes, it works like this.

If you want to randomize them first I have attached a sample workflow for you.

Sample3v3.yxmd

All comments

Emil_Kos

Hi @JP_1,

I like simple solutions. Please let me know if this is something that you have been looking for.

I have used a combination of two sample tools because I believe this is the easiest way to get the desired result.

If this was something helpful please mark my solution as an answer!

Good luck!

Sample3.yxmd

JP_1

Hi, thank you for the reply. Unfortunately this wouldn't work as I am working with circa 5000 records. Some names appear 100 times, some names appear once. Effectively sorting alphabetically or even removing duplicates doesn't alone work as the unique identifier is important as it matches up to other important fields.

shwtswnt

Hello,

i have this below mentioned table. looking help for how to collect sample as per table. table data will change dynamically as Highest and Random numbers will keep changing. i have raw data file where we have Region, Source Highest $ amount and Random Column now want to fetch data / rows following this table dynamically. Tried with batch macro but not able to do the same.

Region	Source	Highest	Random
USA	Apple	1	0
UK	Lemon	13	4
UAE	Apple	5	6
USA	Lemon	8	7
Null	Apple	1	0

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703