Passing Calculated Value as "N Value" in Random Sample Tool

[Allan_F]

I am trying to pass a value into the Sample Tool which dictates the "N Value." 

I have using a Summarize and Formula to provide a total count of employees, and dividing that by 10 to show how many would account for the bottom 10%. I want that value to replace the "N Value" in the Sample Tool so that it is configured to Last N Rows -- therefore pulling the bottom 10% of employees in the sorted table.

[RolandSchubert]

Hi @Allan_F ,

if I got you right, you are looking for the configuration of the  Action tool to change the number of rows? You could try this:

Let me know if that works for you.

Best,

Roland

[Allan_F]

I have the Action Tool set like your screenshot, my issue is connecting the output from the Formula Tool to that Action Tool.

For example the Formula provides "8" I want to pass that "8" into the Action Tool to update the N Value in the Sample Tool to 8.

[RolandSchubert · Accepted solution]

Hi @Allan_F ,

okay, I see. It could be done like this:

I've attached a sample workflow to show how it works.

Best,

Roland

[atcodedog05]

Hi @Allan_F 

Action tool only works in app or macro. Hence you need to place sample tool in a macro like below.

This macro can be used in any workflow like below right-click on the canvas and import the macro.

Learn more on batch macros here: https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923 

Hope this helps : )

[Allan_F]

Thank you all, got it working!