Stepping through variables
I am trying to parse some data from an old file into a new table. There are currently several fields a, b, c, d, e, and f. each had 17 versions, i.e. a1 - a17
I want to separate them into separate records so that one record has a1, b1,c1, etc the next a2, b2, c2, etc and so on.
I tried setting each field to a variable like $a1, then going to the new table, set $count =1, create a new record, then set a to $a$count. Thinking I could loop through the 17 variations rather than having 17 New Record steps with each of the variable combinations.
Is there a way to step through these variable names in a loop?