How to split rows into multiple groups

Question

Hi,

I need to split my data into different groups, based on a category. For example, let's say I have sales data and want to select one sale transaction per store location. I need to take the full population, split by store location, then select one transaction per store. I could accomplish this by using a series of filter tools then the random % sample tool, but I am trying to create a workflow that would work if new stores keep getting added. Using the filter tool, I would need to keep adding filters. Is there a way for alteryx to do this on its own?

Thanks!

rarmstrong · Accepted Answer

You can use the Sample Tool.

Select the option 'Random 1 in N Chance for each Record'

Then select 'Store Location' as a Grouping Field.

This will give you a random % sample of records for each store location