Dynamic Select

AGilbert

The attached solution is how I understand the field info tool can be used to dynamically select certain fields and this week's challenge has me wondering if there is another way. My #419 Submission. 

To simplify the question in 419 I mocked a March Madness Inspired question. The data table has the four #1 seed's scores for completed rounds of the Tournament. The goal is to view each team's most recent and prior round score regardless of how many rounds are added to the table. 

To illustrate, the attached workflow shows my understanding of how to use the field info tool to isolate the identified fields.

I've been trying to implement these expressions in a dynamic select but am unable to do so. The syntax below isn't exactly correct (otherwise I wouldn't be asking this question) but I hope they get the point across.

1. contains([_CurrentField_], m)
   1. where m is the max value of a field
   2. In this example it could represent the highest round number
2. [fieldnumber] IN range(n-1, n)
   1. where n is the count of fields 
   2. In this example the expression would always return the last two columns of a frame. 

Any ideas/thoughts/helpful nudges are welcome!

Thanks in advance!

-AG

dynamic_select_fields.yxmd

Watermark

AG, 

I posted in the challenge itself, but here's a version that creates the dynamic update you're looking for. 

Challenge_419_MT_Solution.yxmd