Hi,
I am new to Import Set and I wanted to load data into 3 tables from a excel sheet. The relationship between these tables is mentioned below
First table 'Test suite' has one-many relationship with second table 'Test Case' and the second table 'Test case' has one-many relationship with third table 'Test'. Here the second table 'Test Case' has a field 'test suite' which is referenced to the first table and third table 'Test' has 'test case' field which is referenced to second table.
I used import set to import the data's and created 3 transform maps.
I have written "onAfter" transform script in the second transform map where the target table is 'Test Case'.
This is my code:
answer=target.sys_id;
I have written "onBefore" transform script in the third transform map where the target table is 'Test'.
This is my code:
target.tm_test_case=answer;
Below image is a Test Suite record which contains 2 test case records.
Below image is first Test Case record which doesn't have 'Test' records listed down, which should have 2 test records as per requirement.
Below image is second Test Case record which have 'Test' records listed down.
Result should be:
I Test Suite record with 2 Test Case records and each Test case has 2 Test records to be loaded in appropriate tables.
But for me, the records are stored correctly in 'Test suite' and 'Test Case' tables
but the 'test' records are loaded only for the last 'Test Case' record. All the previous test case records doesn't contain any 'Test' records listed down in the related lists.
Can anyone please tell me what wrong i am doing here and how i can achieve this.
Thanks,
Jenny
