Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

milos9680
5 - Atom

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.

2 REPLIES 2
ShankerV
17 - Castor

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
18 - Pollux

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.

Labels