How to sample the 5% sample the data with different categories

[vkirans123]

i am working on the file, there are 20 different category i want to get  sample 5 % sample or minimum 1 and maximum 25 . thanks

[vkirans123]

i am working on the file, there are 20 different category i want to get  sample 5 % sample or minimum 1 or maximum 25 . thanks

[griffinwelsh]

@vkirans123 I recommend posting your data or at least a sample of the format with random values if the data is confidential

[Qiu · Accepted solution]

@vkirans123 
The Randome % sample is not having a Grouping feature. 😂

Therefore the batch macro comes to be helpful.

I am not sure the requirement of "minimum 1 and maximum 25" so I made two condition,

1 is for 5% sample only

2 is for %5 sampling and limite the sample records to be under or equal 25 records.

[vkirans123]

thank you for your prompt response.

[vkirans123]

this is exactly what i needed . thanks. is it works the same if my source file has multiple tabs.