Test Data Manager

 View Only
  • 1.  Generator publish with reference column

    Posted Jan 19, 2023 09:46 PM
    Hi All ,
    Below is the scenario .I need to publish records in Col1 in child table based on values in Col2 (Col1 values from Parent Table )  .This publish is part of a cloning activity where values in col1 in both tables are generated and rest of the values selected from the source . Please help us how to achieve below result .

    Parent Table                      Child Table 
    ---------------                    ---------------
    Col1                                  Col1 , Col2
    1                                         1    ,   A
    2                                        1    ,   B
    3                                        1   ,    C
                                              2  ,    A
                                              2  ,    B
                                              3  ,    A
                                              3  ,    B

    Thanks,
    Krushna


  • 2.  RE: Generator publish with reference column

    Broadcom Employee
    Posted Jan 20, 2023 04:45 PM
    I dont follow what you are saying but based on the example you have shown, you publish rows for the parent table and then you can use that column (variable) for the value in col 1 of the child table.   multiple rows in the child table, you could add additional rows and use a variable such as ^col1(-1)^.  What determines the number of additional rows in child table for each col1 value?