Adding Additional Repeats from other Fields

Jon,

My suggestion is to use your own counter rather that the %f1 established with the ITERATE for your outbound, MATH ADD.

I typically use something like %f99 and work my way down for my own counters. That is like an eye catcher for me for maintenance. If I see %g99 or %f99 or %l99 or %s99 I know those are my counters not ones established by an ITERATE and I should see specific handling for them.

I usually 0 out my counter up from with copy =0 to $%f99.

Then for you math add statement make it $%f99 =1 MATH ADD $%f99.

Your location I beleive is fine.

You need to use your iteration counter of %f1 on the source side in your path for the field you are iterating over and on the destination side use %f99 in the path for the destination instead of the %f1.

Use the math add statement on you PID:3 iteration just to keep it at the proper iteration.  Without reinitializing %f99 also use it for the iteration over PID:4 when you copy PID:4 to PID:3 for example using the correct paths.

Copy =0 –> $%f99

Iterate over PID:3(You can use %f1)

    Copy PID(%f1):3 –> PID(%f1):3

    MATH ADD $%f99 =1 –> $%f99 (This is only to keep the count)

Iterate over PID:4(You can use %f1, it initializes each time iterate is call)

    Copy PID(%f1):4 to PID(%f99):3

    MATH ADD $%f99 =1 –> $%f99 (This is only to keep the count)

Hope this helps…