Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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