Test Data Manager

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.

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

Hi Rajasekhar

You already have it scoped out!

You can do this with a table lookup.  Create a Table that has your exact setup that you have here, generate the key into that table, and simply populate your columns with your columns based on the key value.

Cheers!

Les

Thank You Les.

HI Rajasekar,

I assume you have created a seed list for the Address table where you have added these columns HouseNo, IntegrationID and LocationID. 

Using the function: @randlov(0,@seedlist(Address)0,1)@. 

Table of Seedlist : Address 

1 mention in the function, its referenced to HouseNo. Similarly, you can reference other values. 

Also, you would able to add more address to seedtable in future when you foresee to add more addresses. 

Hope it helps.

Thanks,

Jagadeesh

Thank You Jagadeesh. Sorry for late reply. It worked for me.