Random - automatically input random N records which is based on a calculation

[milos9680]

Hi everyone,

Newbie alert here,  I was wondering is there any way where i can automatically input the N, no of random generator based on a calculated field from another formula process?

eg,

If the sample size calculation determines that 25 samples is required, it will input 25 into number of records as 25.  

Thanks in advance.

[ShankerV · Accepted solution]

Hi @milos9680 

If I understand your scenario correctly, the solution I propose is we can take the count of the records using summarize tool.

Use that as input N for any other calculation purpose.

Many thanks

Shanker V

[apathetichell · Accepted solution]

Yes! You can! Watch this video for a quick intro to batch macros.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

Basically you'll feed the number of records you want into the control parameter, and the control parameter into an action tool - which will update the N in your sample tool. Super cool - and super useful.