Random samples selection with reading from file

[SH_94]

Dear community,

I would like to ask about the samples selection function in alteryx. Currently i am using the random% sample tool to randomly select the samples from the excel file as per screenshot below. However, i would like to ask the alteryx to read from the excel about the number of random N records instead of i type in the tools as per screenshot below.

Example of excel data below whereby i would like to ask Alteryx to read from the data in excel instead of i key inside the tools.

May i know is it possible to do it in alteryx or any other functions that we can use?

Many thanks in advance

[flying008]

Hi,@SH_94 

Maybe you need make the random sample tool to a macro, control parameter to update the value [random number], the you can exec.

[SH_94]

Dear @flying008 ,

Thank you for your prompt response.

Would you be able to guide me on this or do you have any workflow that can shared?

Below is my source file and samples selection file.

Thank you

[ArtApa]

Hi @SH_94 - Here is how you can do this: