Sampling

[MeaadAlsades]

Dear Alteryx Community,

I want to ask if there is a tool for sampling more than one character (if I have more than two sections to consider when choosing the sampling data, ensuring equal representation of data values from all these sections).

[OTrieger]

@MeaadAlsades 

Have you consider the Sample Tool?

[MelGibson · Accepted solution]

I am not sure of way to do this with the tools available. But could you could create a new field by concatenating those two fields or however number of fields you want. In that same formula tool create a random field using the formula rand() then connect that formula tool to a sort tool sort by your concat field and then random field then add your sample tool and take whatever sample you want. 

Or you could add two sample tools and join them if you are not wanting the same row of data

Or you could use the oversample field tool if your second field has a specific data you want to bring in.