Load one excel for multiple tables

[Lean S]

Hi All,

I am working on import sets and transform maps. I wanted to load one excel sheet for loading in multiple tables.

This is for loading into test case and related test case steps instance

Under test plan I have to load test cases as first step and second I have to map to test case -> test case step

so from one excel sheet 

test plan -> I have load test cases

test case -> to load its related test case steps.

How can achieve using one excel sheet. Any specific coding needed for this.

Thanks,

Lean S

[asifnoor]

Okay, all looks good.

The transform map is good.

Test without source script first. and check if the test_case_instance in your 2nd table got filled with the reference entry or not?

[Lean S]

Hi,

I tested without source script. Its not saving in the correct reference field. I am giving as seen in screenshot to Test Plan field but its been not saving in it.

Thanks,

Lean S

[asifnoor]

In the transform map under reference value fiedl name (as per screenshot), change the value to tm_test_plan ad test it.

[Lean S]

Hi,

Changed to the element name and its saving in a different field instead of test plan field.

Its saving in test case field.

Thanks,

Lean S

[asifnoor]

Hi,

No, that is correct.

In your test case step table, you need to refer to test case instance table and the relationship will be built only thorugh test_case_instance field, which is correct.

The test plan field is for comparing the test plan number in xls with the test case table (test plan number) and get the sys_id for reference.

Kindly mark all the comments as helpful if this has solved the prolbem.