In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Generate sample records from the big dataset based on 2 columns

hash_89
8 - Asteroid

 I need to generate 3500 samples and need some representation of different combinations.

 

Here is how the data looks like

 

NameYearSubject
ABC2021Math
DEF2022English
GHI2022Math
GIH2023English
JIK

2024

Math
LHM2024English
KIK2024Science

 

I need to generate samples for combination of Year & Subject. It doesn't matter how many in each combination, but the overall sample should have records for all possible combinations in year & subject.

 

can anyone help?

4 REPLIES 4
apathetichell
19 - Altair

Sample tool. select both columns in the group by. choose an amount. You will have that many items for each grouping.

hash_89
8 - Asteroid

I did select the 2 columns, but it gives me more than 3500 for each year. 

binuacs
21 - Polaris

@hash_89 Another approach

image.png

apathetichell
19 - Altair

@hash_89 N is the number of entries you want per combo. you are putting 3500 samples PER GROUPING...

Labels
Top Solution Authors