Test Data Manager

  • 1.  Repeat column twice in GT datamaker

    Posted 11-29-2016 12:48 AM

    Hi,

     

    Can you please help me on below scenario

     1. From a given table i have x and y columns

     2. x column will be increment till 'n' rows - we can achieve it by using nextval function this is clear

     3. y column data value should be repeat twice - i need help on this how to achieve

     

    example of data to be below(Here eno is my x cloumn and internal_id is y column)

    eno    empname      Internal_id

    1        satish             1001

    2        kumar             1001

    3        raj                   1002

    4        anush             1002

    5        kulkarni          1003

    6        madhav          1003

     

     

    Thanks in advance

     

    Regards,

    Satish.



  • 2.  Re: Repeat column twice in GT datamaker
    Best Answer

    Posted 11-29-2016 09:00 AM

    Hi Satish, 

     

    Here is some documentation on setting up repeat counts and working with columns:

     

    Working with Columns - CA Test Data Manager - 3.8 - CA Technologies Documentation 

    Publish Data - CA Test Data Manager - 3.8 - CA Technologies Documentation 

    Configure Publishing Behavior - CA Test Data Manager - 3.8 - CA Technologies Documentation 

    Data Generation Functions and Parameters - CA Test Data Manager - 3.8 - CA Technologies Documentation 

     

    Note: If you are not using TDM 3.8, you can change the 'Version' of the documentation you are seeing by choosing from the drop down list in the top, right-hand corner of the screen. 

     

     

    If you have any further issues, please open a support case on https://support.ca.com/irj/portal/newhome  or calling CA Customer Care at one of these numbers Contact CA Support - CA Technologies

     

    Best regards,

    Taylor



  • 3.  Re: Repeat column twice in GT datamaker

    Posted 11-30-2016 04:21 AM

    Hi Satish, 

     

    You can use below approach.

    Say for example you are creating the number using nexvalue for Internal_id.

     

    Row 1 ~nextval~

    Row2 internal_id(-1)

    Row3 ~nextval~

    Row5 internal_id(-1)

     

    I am not sure the value in Row3 will be next value to in Row1 but internal_id(-1) will definately will be same as row1 value.

    Please let me know if this works.

     

    Regards,

    Raju Devolla.