Test a transform map before executing it on everything

[joshuamayes]

I'm building a transform map that uses a lot of scripting.   I'm new to scripting, but in my experience Servicenow is kind of wonky in what works when scripting based off of how it is executed.

Is there a way for me to test a transform map on only a few records before I apply it to an import set that consists of thousands?

[Michael Fry1 · Accepted solution]

You don't say how/where the data is coming from, but definitely how you'd want to proceed. Just use one or two records, even if you have to put them into a spreadsheet first to run through your map to test it all out.

[joshuamayes]

Thank you Michael,

I'm an idiot and that's definitely the right way to go about this... not sure why I didn't think of that.

[Community Alums]

Another option is to use the "Test Load 20 Records" UI Action on the Data Source record you get after loading the file.

You'll have to go through a few more clicks though since the Import Rows are loaded and set with a state of "Test" so the Transform Map won't actually run.

To go around this, go to the Import Set itself, click "Reprocess" followed by "Transform" and then your Transform Map should run normally.