AnsweredAssumed Answered

Stepping through variables

Question asked by MarkGores on Dec 22, 2014
Latest reply on Dec 23, 2014 by philmodjunk


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?