Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sampling

MeaadAlsades
5 - Atom

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).

2 REPLIES 2
OTrieger
12 - Quasar

@MeaadAlsades 

Have you consider the Sample Tool?

MelGibson
10 - Fireball

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. 

Labels