Using variables from input data

Question

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 rowsfirst sectionsecond sectionthird section5051530

dataset (abbreviated)

idpriority12345a112345b112345c212345d212345e312345f3

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)

dpan · Answer

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!

Robin_McIntosh · Answer

@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.

Discussion_Dynamic_Sample.yxmd