While performing data generation we use NEXTVAL Sequence function for the parent table. For the child tables we used reference lookup using the tablename and columnname.
We have created the variable and While publishing the data to target environment for single value, it is updating fine and if we use multiple values, the column value is getting duplicated in child tables with 1st record value.
Currently, we are using 4.9.333.0 version of CA Portal.
Release : 4.9.1
Component : CA Test Data Manager - Others
We have discussed this with Level 2 Developer and unfortunately you are attempting to use the product beyond it's current capabilities. We do not have a method in place to do variables inside of references. To enable this would require a program framework re-design. This is a 4-8 month endeavor that is not currently slated for a time slot in the Development Sprints.
Level 2 Developer did suggest a more direct mapping model which is given below but it is not as dynamic as you had hoped for: