This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As opposed to using a Macro, which adds an extra level of complexity, you can reproduce the needed functionality in a series of tools in the main workflow.
Your data is represented by the 1st Generate rows tool. The summarize tool is counts the number of records in the input data and this number is appended to the data. The Percent needed Text Input contains the percentage that you want to sample. This is also appended to the input data. From here it's a slightly modified randomize algorithm. Generate a random number for each row. Sort by this random number and add a record ID called [RandomOrderID]. The final filter is where the modification comes in. The filter used here is
The ceil() function returns the next integer larger than its argument if this input isn't already an integer. So 1 percent of 201 is 2.01 and the ceil function pushes this up to 3.