Add Random X Records and Random % of Records to Sample Tool (with grouping option)

[cbridges]

It would be great to get a random x number of records or x % of records for every grouped field in the sample tool.

Right now, the sample tool is lacking the random % feature and the random % tool is lacking the group by feature.

[jdunkerley79]

This is achievable in the Sample tool. Basically just need a way to randomise the data order then take top x % or x rows.

One simple way is to use a formula tool to add a UUID field and use this as a sorting field (sample here).

That said agree nice extension to have better sampling tools.

[cbridges]

That's very cool @jdunkerley79! It will work well as a substitute till we get the baked in version!

[Atabarezz]

how about the stratified case, iterative macro will do?

[jdunkerley79]

I'd probably go for:

add a group field to identify strata

then use a summarise tool to get counts for each group and join back to input

Add a random number and then sort by group and then random value field

Use a multi row formula to add the rank within each group

Finally use a filter where rank <= percent of count needed.

A bit of a roundabout route but would do what you want I think.

[Atabarezz]

Well iteratively selecting a random % of a single strata for all would do I presume,

To define a strata we need to select one or more combination of columns, tile each column etc.

I'll try one and post it, maybe you can turn this into a tool JD?

[jdunkerley79]

happy to. Give me a demo set and I'll see if I can create a macro with selectable grouping etc

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!