Repeat column twice in GT datamaker

[satish.kumar.enni]

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.

[gilta03]

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

[raju devolla]

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.