Update Value with Action tool, based on a case

To the community,

Hoping someone can help me with this. I would like to create a sample of my data, based on a category. In the attached attempted macro i have made it is based on whether the case is Red or Blue (my actual dataset has around 50 different types). I have tried using an action tool to update the validation and estimation values in a create samples tool, but this doesn't work at the moment. In the macro the choice made in the create samples tool gives a 70,20,10 split, (although when i then put the macro into a workflow it gives me (0, 0, 100%). I would like, for example a 80,10,10 split for the blues and 50,40,10 for the reds to be output at the same time. Any thoughts on getting this method to work or another one would be much appreciated.

Thanks,

James

Test create sample Macro.yxmc

Macros

Interface Tools

Accepted answers

NickC

Hello James,

Good meeting you yesterday, please see solution attached.

The key to solving this was to put it into a batch macro so that it can process each of the different colours in batches. Make sure you add the browses after a batch macro to ensure it pulls through all of the data.