Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to copy from one custom table to another within service-now

ty_roach
Tera Guru

I am trying to copy data from one table (a custom table that extended change_request) into another custom table (one that extended task).

It runs successfully, saying that it processed all 63 records and performed 63 inserts (which would be correct), but when I look at my target table for content, it appears empty.

My Data Source is defined as a Type=File, Format=XML. I've taken what I think is a reasonable guess for the XPath for each row value (e.g. //) as well as for File path (e.g. /.do?XML).

Any ideas??

6 REPLIES 6

There's nothing in my "Import Sets". When I click that module, it shows an empty list and there's not even a "NEW" button to add an import set.

As mentioned before, the wiki leads you to believe that you do not need a data source, which, if I'm understanding the terminology right, should feed the Import Set.

Import Sets: Table of all import sets. "An import set" is a set of records imported from a Data source, that can be mapped to an existing table and serves as a staging location for storing imported data.

we are doing a table to table copy (within service-now).

Not sure what to do next. I would have imagined this to be the easiest of all operations (table to table within service-now).


ty_roach
Tera Guru

Am I suppose to first do a transformation map from the source table to an import set (imp_computer being the target for this stage of the transform), then create a second transformation map to go from the imp_computer (import set) into the destination target table????