Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Select different samples, from different columns, based on dynamic table results.

kdvr
5 - Atom

I hope the subject name I selected helps explain a bit what I'd like to accomplish.

 

I have a single-row table where each column marks a different sample size totals needed based on that time bracket.

 

1.jpeg

 

I have a second table where those columns are represented by 1 or 0, 1 being a valid sample/row, and 0 means it's not a good sample. Essentially, I got the first table by adding all of the 1s in the second. 

 

2.jpeg

 

What I'd like to do, based on the total given in that first table, is to select that number of records in my second table. So, the result would only keep 95 records from "Sum '11-'15", and 101 records from "Sum '16-'20". Ideally at random, as opposed to just first N records.

0 REPLIES 0
Labels
Top Solution Authors