I'm converting an old file with several repeating fields. I'm trying to split these into separate records while matching the correct values in each record.
One field is Mon, Tues, Wed, etc.
Next is A, B, C, D etc.
Finally there's Orange, Yellow, Blue, Green
There are five values in each repeating field, but not all the values are applied, i.e.
Record one could be Tues, C, Green
Record two might be Mon, A, Orange
and so on.
I've tried using the List () to get the values in one field and then the GetValue (field;x) to identify the correct values in the following fields. I keep getting a List of all the values in the resulting fields.
Any help is appreciated.
All the best,