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

[Ankur Bawiskar · Accepted solution]

Hi,

From single excel file you can transform data to multiple target tables.

I assume you must be having a data source to which this excel would be attached

Define the transform maps accordingly in sequence with the Order for those target tables

1st load the Test Plan

2nd Load the Test case

Regards
Ankur

[Lean S]

Hi Ankur,

Can you please help me bit descriptive on how to do sequence transformation with small scenario 

Thanks for the help!

[Ankur Bawiskar]

@Lean S 

Consider you want to load data to incident and incident_task table

incident_task -> table has field to indicate this task belongs to which incident

So the 1st transform map would be to load into incident table

2nd transform map would be to load into incident_task

Regards
Ankur

[Ankur Bawiskar]

@Lean S 

refer links below for help

Can I insert into multiple tables using a single Transform Map?

How to load data from a excel sheet into 3 tables at a time

Regards
Ankur