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