Load one excel for multiple tables

Lean S · ‎10-29-2020

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 · ‎10-29-2020

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

asifnoor · ‎11-04-2020

Great.

Now go to your 2nd transform map.

Map this new field in xls with the test instance column of your table.

And under reference field value name, mention the column name of your 1st table (that is newly created).

No need of source script.

This should work

Lean S · ‎11-04-2020

HI,

Now its working. Great for that your assistance.

A small query this will work if we have

1 test case -> 1 test case step

now we have like

1 test case -> 10 test case steps

then how we can differentiate and make it work. Kindly suggest

Thanks,

Lean S

asifnoor · ‎11-04-2020

In your xls, if there are 10 test case steps, your test case data will be duplicated in the green section.

So we shall not have any issue. It will work.

Only thing you need to ensure is in your 1st transform map, make this new field in xls as coalesce. That way your test case data will not be inserted multiple times.

Kindly mark the appropriate comment as a correct answer and all my other replies as helpful for the time and effort spent.

Lean S · ‎11-27-2020

Hi,

Really Sorry for turning back after a long time, I was totally off from work for long time.

I made unique new field as colease but still Test cases are creating duplicates. So how we can make like below:

1Test Case -> 1Test CAse step (working fine)

1 Test Case -> 10 Test Case steps. (Made new field as colease )

in this scenario I am getting duplicates created for test case , this should not happen.

Please guide me how we can map already created test case 1 -> 10 test case steps. with out creating TC duplicates.

Thanks,

Lean S

asifnoor · ‎12-10-2020

Hi

Sorry, i missed your message. an you share the sample xls with the new column and also let me know on which table you hve added this new column.