I am am currently trying to pick samples from a very large population, which normally takes hours, and I am trying to see if its possible to automate this with alteryx, given that this is a task that I perform frequently. I have attached a sample excel file that includes Fund Names, Asset ID's, and Asset Descriptions, and I need to pick samples based on the following criteria:
Criteria 1: This determines how many samples I need based on the total count of the securities within each fund. For example if a fund has more than 200 securities then I would need 16 samples, between 100 and 200 securities would be 10 samples, etc (This is shown in the attached workflow)
Criteria 2: The samples that are selected have to be unique across all the funds. For example, if I picked Asset ID "12345" from Fund C021 then this security could not be selected for any of the other funds, it would be removed from the population essentially.
I think I need a batch macro to do this, but I am still pretty new to Alteryx and am wondering if someone can lead me in the right direction. Thanks for any help you can provide.
