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

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.

Workflow

Preparation

Interface Tools

Accepted answers

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

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

Best,

Roland

UpdateSample.yxzp

All comments

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

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.

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

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

Best,

Roland

UpdateSample.yxzp

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 : )

Thank you all, got it working!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703