Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home New York Now Platform Administration Now Platform administration Data management Import sets Transform maps

    Transform maps

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Transform maps

    A transform map is a set of field maps that determine the relationships between fields in an import set and fields in an existing ServiceNow table, such as Incident [incident] or User [sys_user].

    Figure 1. Import process transform
    Import process transform

    After creating a transform map, you can reuse it to map data from another import set to the same table.

    The Transform Maps module enables an administrator to define destinations for imported data on any tables. Transform mapping can be as simple as a drag and drop operation to specify linking between source fields on an import set table and destination fields on any table. Use transform mapping to map source and destination fields dynamically.

    Transform considerations

    Auto-mapping
    Double-check that fields the system maps automatically are actually required. For example, encrypted passwords probably should not be mapped.
    Mapping reference fields
    If you are mapping reference field data and the sys_id does not exist, the sys_id could potentially appear in the target record as the DisplayValue, and this may be undesirable.
    Field mapping a large number of reference fields incurs additional performance overhead because the system checks that the referenced sys_id actually exists before performing choice actions at the field level.
    Note: You can bypass the performance overhead using transform scripts such as onBefore (on the assumption that there is no requirement to validate the import of reference fields). For example, target.<field_name> = source.<field_name>.

    Using multiple transform maps

    Multiple transform maps can be applied to a single data source.

    One import set row is created per transform map, which can cause a large number of temporary records to be generated.
    Note: If you use multiple transform maps for the same import set, the transform creates multiple entries in the import set table.

    Run multiple transforms off a single import set

    Users can select multiple transform maps during data import.

    The selected transform maps will be executed on the same import set in the order specified.

    Figure 2. Multi-map transform
    Multi-map transform

    Transform map scripts

    Transform Map scripts allow you to customize import operations using a robust programming interface to introduce advanced logic.

    A transform map script executes as events occur while an import set is being transformed onto a ServiceNow table. Transform Map scripting is fully integrated into the ServiceNow scripting environment. There are two types of Transform Map scripts:
    • Explicit Transform Map scripts, which explicitly define mapping relationships
    • Transformation Event scripts, which modify the processing of events at different stages of a transformation

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Transform maps

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Transform maps

      A transform map is a set of field maps that determine the relationships between fields in an import set and fields in an existing ServiceNow table, such as Incident [incident] or User [sys_user].

      Figure 1. Import process transform
      Import process transform

      After creating a transform map, you can reuse it to map data from another import set to the same table.

      The Transform Maps module enables an administrator to define destinations for imported data on any tables. Transform mapping can be as simple as a drag and drop operation to specify linking between source fields on an import set table and destination fields on any table. Use transform mapping to map source and destination fields dynamically.

      Transform considerations

      Auto-mapping
      Double-check that fields the system maps automatically are actually required. For example, encrypted passwords probably should not be mapped.
      Mapping reference fields
      If you are mapping reference field data and the sys_id does not exist, the sys_id could potentially appear in the target record as the DisplayValue, and this may be undesirable.
      Field mapping a large number of reference fields incurs additional performance overhead because the system checks that the referenced sys_id actually exists before performing choice actions at the field level.
      Note: You can bypass the performance overhead using transform scripts such as onBefore (on the assumption that there is no requirement to validate the import of reference fields). For example, target.<field_name> = source.<field_name>.

      Using multiple transform maps

      Multiple transform maps can be applied to a single data source.

      One import set row is created per transform map, which can cause a large number of temporary records to be generated.
      Note: If you use multiple transform maps for the same import set, the transform creates multiple entries in the import set table.

      Run multiple transforms off a single import set

      Users can select multiple transform maps during data import.

      The selected transform maps will be executed on the same import set in the order specified.

      Figure 2. Multi-map transform
      Multi-map transform

      Transform map scripts

      Transform Map scripts allow you to customize import operations using a robust programming interface to introduce advanced logic.

      A transform map script executes as events occur while an import set is being transformed onto a ServiceNow table. Transform Map scripting is fully integrated into the ServiceNow scripting environment. There are two types of Transform Map scripts:
      • Explicit Transform Map scripts, which explicitly define mapping relationships
      • Transformation Event scripts, which modify the processing of events at different stages of a transformation

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login