Issues with Set Field script step with repeating fields.

I have a repeating field in one file that may have one of more values per repetition in this one field. I am trying to pass this values from one field in one file to another in another file.

The fields are both repetitive fields with the same number of repetitions (6). The original field is global which makes it possible for these values to be passed through the relationship between the two files.

I have tried the following:

- Using the Set Field script step and the calculation is pointing to the field containing the values. Done one per repetition.

- Using the E.g. Set Field[6] script step again and the calculation contains GetRepetition ( myfield ; 6 )

Tried many different combinations trying to pass this data. It did it once for some values but not all the repetitions.

Thanks

Alberto.

Could you check that Marketing.Link::Global.DepartmentAdvised is REALLY a repeating GLOBAL field ?

Issues with Set Field script step with repeating fields.

I have a repeating field in one file that may have one of more values per repetition in this one field. I am trying to pass this values from one field in one file to another in another file.

The fields are both repetitive fields with the same number of repetitions (6). The original field is global which makes it possible for these values to be passed through the relationship between the two files.

I have tried the following:

- Using the Set Field script step and the calculation is pointing to the field containing the values. Done one per repetition.

- Using the E.g. Set Field[6] script step again and the calculation contains GetRepetition ( myfield ; 6 )

Tried many different combinations trying to pass this data. It did it once for some values but not all the repetitions.

Thanks

Alberto.

This is not the problem you should be solving.

The problem you should be solving is getting rid of the repeating fields.

Please describe your database in more detail.

Note also that while getRepetition is valid, square bracket syntax is easier: Set Field [ somefield; otherField[5] ] as opposed to Set Field [ somefield; getRepetition(otherField; 5) ]