AnsweredAssumed Answered

How to generate the data in a column based on other column value.

Question asked by Rajasekhare on Mar 4, 2017
Latest reply on Aug 1, 2017 by Rajasekhare

Hi team,

 

I am generating synthetic data using CA TDM. I am importing XML file and adding data generation rules to the tables. 

 

My requirement is:

I have 3 fields in address table.

HouseNo, IntegrationID and LocationID. 

I have set of data for these fields as shown in the below table.

 

HouseNoIntegrationIDLocationID
111111
222222
333333
444444
555555
666666

 

First i will generate the HouseNo, based on the HouseNo value, IntegrationID and LocationID values have to be picked from the list.

Here for HouseNo, i am using the function: @randlov(0,@list(1,2,3,4,5,6)@)@, so any one value will be picked from the list.

If the HouseNo is picked as 2, then in IntegratioID i want pick the value as 22 and in LocationID i want pick teh value as 222.

 

Could anyone please let me know how to generate the data like this.

 

Thank You.

Regards,

Rajasekhar

Outcomes