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.
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.