Looping through Found Sets
My question relates to the outline of a script suggested here to help divide my database into random cohorts of 1/12 total records.
Records in my table are assigned one of 8 Categories (text field) and 6 sub-categories (calculation number result). I want to perform a repetitive function on each of the 48 combinations but I'm not sure how to structure the loop in the script step.
Steps in the Script
- Find Category 1 AND sub-category 1, perform function
- Find Category 1 AND sub-category 2, perform function
- Find Category 1 AND sub-category 3, perform function
Repeating this for a total of 48 combinations of category and sub-categories seems tedious and like an ideal situation for a Loop.
Is there a way to create a looping process to go through all 48 combinations without having to copy / paste every combination in a script that steps through each in sequence?