dynamic change of sample size based on number of records

[starfailure]

Greetings,

This probably isn't very complicated or difficult, but I'm a noob.

I need to count the number of records in an output, then use that number to determine (update) the value of N in the Random % Records tool, and apply to the same output.

Please could someone help me arrive at a solution?

[morr-co]

Hi @starfailure : the attached macro should do this for you. Simply map the N value to the upside down question mark input (control parameter)

[starfailure]

Thanks @morr-co!  Appreciate the response.

A couple follow-ups.

- What upside-down question mark?

- How do I incorporate a macro like this into a standard workflow?

[morr-co · Accepted solution]

No worries, below are the steps you need to take. A "macro" is essentially a workflow that you can use in another workflow. To accomplish this:

1. Save the attached workflow above to your local machine
2. In the workflow you are building:
   • Right click on the canvas
   • -> Insert
   • -> Macros (last option at the bottom)
   • -> Click Browse...
   • Select the file you just saved to your machine
3. You will then see the macro on your canvas as it appears in the image below. To make it work:
   • Map the N input to upside down question mark input on top
   • Map the data you want to sample to the second input
   • When you click on the macro, select the Questions tab, and make sure your field containing N is mapped in the drop down.

[Qiu · Accepted solution]

@starfailure 

While @morr-co is taking the break, and utilize the macro to give a sample here. Hope it helps.

The question mark indicates that there is a question from Macro, requiring user configuration.

If helps, appreciate if you would mark it as accepted.

[starfailure]

Thank you, both! 

I think you've provided the missing pieces.

Now to put it together..

[Qiu]

@starfailure Appreciate the mark. Have a nice day!

[rbelski]

Thank you for your macro instruction and example.  I've used it on a multi-stage sampling process that I've puzzled over all day!