Adding Macros to my Sample Selection Workflow.

[STerrace001]

Hey Everyone!

I've created a workflow that is able to take a file from one folder, select N amount of samples at random, and output the results to a different folder.

However, I want to make this tool a bit more powerful in two ways:

1. Having the workflow run for every file within a folder and outputting a new file for each file inputted.

2. Having the number of samples being selected be based on the population [P(Population) = 1, N(Samples)=1| P=4, N=2| P=12, N=5|P=52, N=15|P=250, N=40|P=250+, N=60]

I understand that this can be done with macros but try as I might I have been unable to make them work (I'm still a bit of a noob). Is anyone able to help me out? I've attached my current workflow for reference.

Thank you!

[IraWatt · Accepted solution]

Hey @STerrace001,

Here's an example of how I would do this:

Essentially the the analytical app lets you pick two directories, one output one input. It also lets you select the number of rows from the sample tool. This information is the passed to a macro to output each file.

A lot to unpack here any questions or issues please ask :)
HTH!
Ira

[Qiu]

@STerrace001 

If you could provide sample insenstive data, I am sure the people here can look into it.😀

[STerrace001]

@Irawatt Wow! Thanks for the help here this seems like the best solution. Unfortunately my organization seems to be stuck on an older version so I can't open your workflow but I'm hopeful that I can reverse engineer it from your explanation!

[IraWatt]

Hey @STerrace001,

Let me know if you have any issues. Also you can change the version of workflows by right clicking them and opening with notepad:

Just change the underlined details