Random samples selection with reading from file

Question

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

Source File.xlsx

Samples selection file.xlsx

ArtApa · Answer

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

RandomAA.yxmd

SH_94 · Answer

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

Source File.xlsx

Samples selection file.xlsx

flying008 · Answer

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.