Select Randomly one person from an address

Hi Everyone,

I have few name and address information in my file and multiple persons are present in one address. Will Sample tool help me to select randomly any one person living in a particular address?

Any guidance will be highly appreciated.

Thanks in advance,

Best Practices

Help

Accepted answers

AngelosPachis

Hi @Bitopi

I don't think that a simple sample tool can do it because it doesn't have the option to randomly select a single resident per address.

You can use a formula tool to assign a random number between 0-1 to each resident and then keep only the resident with the highest number assigned per address. This is dynamic, so every time the workflow runs, new number will be assigned to the residents of each address

Hope that helps,

Angelos

example.yxmd

All comments

AngelosPachis

Hi @Bitopi

I don't think that a simple sample tool can do it because it doesn't have the option to randomly select a single resident per address.

Hope that helps,

Angelos

example.yxmd

Bitopi

Thank you for the help

Kurohits

Hi @Bitopi

You can easily do that with the help of Random % sample tool. This tool picks up records randomly and displays the output. each time you run the workflow, the result gets changed.

Check my solution.

Random Selection.yxzp

AngelosPachis

But I think the requirement here is to randomly get a single person from each group and the Random % Sample tool doesn't have an option to group by.

For example if your input is something like this

you want to get one person from address A and one from address B, and I don't see how the Random % sample tool can do that. Correct me if I'm wrong @Kurohits @Qiu 🤔

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703