Adding Macros to my Sample Selection Workflow.

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!

Sample Workflow.yxmd

Macros

Accepted answers

IraWatt

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

Example.yxzp

All comments

IraWatt

Hey @STerrace001,

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

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

Example.yxzp

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335