Using variables from input data

[dpan]

Beginner here. Is it possible to input data from an excel sheet, ie number of rows to filter, and use that to extract data from a dataset? 

settings xls sheet

total rows	first section	second section	third section
50	5	15	30

dataset (abbreviated)

id	priority
12345a	1
12345b	1
12345c	2
12345d	2
12345e	3
12345f	3

Input the data from settings xls sheet, and filter my dataset as such:

Priority = 1    first N rows (where N = 5)

Priority = 2    first N rows (where N = 15)

Priority = 3    first N rows (where N = 30)

[Robin_McIntosh]

@dpan Not sure if there is a specific tool for Dynamic Sample, however, I think this gets to the result you are expecting.  You would then update the "Priority N Samples" file to indicate new prioritiy #'s and respective sample sizes.  Let me know.

[dpan]

Coming from Java programming, Alteryx conceptually is such a different programming tool. Your solution is beautiful, and I am beginning to see the different approach to data manipulation this tool requires. Thank you for the insight!