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.
Solved! Go to Solution.
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
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.
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
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 : )
Thank you all, got it working!