Hello! Long time reader, first time poster.
I'm working with a dynamic select tool in an effort to identify columns that may move around from run to run. In my source data, odd numbered columns contain "Field Names" for the system it interacts with. The fields to the right of the "Field Name" columns contain the data for that row. I need to figure out how to find the "Field Name" field by name in dynamic select (which I've done) AND THEN select the one to the right of it. The field numbers may change based on any number of factors, so the ID by name, then position tactic is the most reliable. The attached table contains an example, where 40 is the field name. That is the only value in that column. The next column over is the value, which can change. What is constant is the relationship between the left and right columns.
| F65 | F66 |
| 40 | 5.23 |
| 40 | 17159.74 |
| 40 | 26039.42 |
| 40 | 0 |
| 40 | 0.1 |
