We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Feed a seed into the random sample tool

VR
5 - Atom

Hi all--Alteryx beginner here. I have a large file that I need to run multiple random samples using pre-determined seeds. I have a list of the seeds but can't figure out how to "feed" that listing into the seed input in the random sample tool--the only option I see is to type in a number. I basically want to provide the sample tool two inputs: 1) the file i want sampled, and 2) a listing of seeds to use when generating the sample. Is it possible to 1) feed a listing of seed into the random tool, and 2) have the tool loop and provide separate outputs for each seed provided? I'm very new to Alteryx, but it seems like I would need to edit the tool as a macro, but might need some guidance (couldn't find a clear link/answer on the boards to help me move in the right direction). Thanks in advance!!

4 REPLIES 4
apathetichell
20 - Arcturus

Yes. You can use a batch macro to feed a random seed in to the Create Sample tool or the Random Sample tool. If you can explain your full workflow (i.e. are you feeding into a model etc) that can help.

 

 

Qiu
21 - Polaris
21 - Polaris

@VR 

Can you give some details about the list of seeds?

like an array of numbers for %?

VR
5 - Atom

here is a snap of the workflow--super basic 

VR_0-1624404274199.png

Snap of the seeds 

VR_1-1624404294110.png

snap of the config for the random sample tool--the random seed is what im trying to feed from the file

VR_2-1624404344725.png

 

apathetichell
20 - Arcturus

try this...

 

note - the seeds here become field names with the other fields (1-100) being the random samples. the other possibility is an output (excel file etc) with each randomseed as the name and the sample as the data.

Labels
Top Solution Authors