Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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