> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.configbot.ai/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# ConfigBot for ServiceNow - Transform Map

The **ConfigBot for ServiceNow – Transform Maps** module enables users to efficiently reverse, validate, compare, and automate Transform Map configurations within ServiceNow. The module supports key transformation components, including **Transform Maps, Field Maps,** and **associated transformation scripts**, allowing users to analyze and manage data transformation configurations across ServiceNow instances and helps users improve the accuracy, consistency, and efficiency of data transformation and integration configuration management. 
 
The following article explains how to use the **Transform Maps** module in **ConfigBot** to perform different operations.    

**Step 1: Log in to ConfigBot** 

Enter your **username** and **password**, then click Submit to access the portal. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ktb42s.png)

**Step 2: Access the Transform Map Module** 

From the **Home Screen**, Navigate to **Integration** and click on the **Transform Map** module tile 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_gn10hg.png)
**Step 3: Create New Iteration** 

Click the Add Iteration button 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1q8yuie.png)


* Enter the Iteration Number 
* Select the Workspace or ADD NEW WORKSPACE 
* Enter Host Address 
* Choose the Instance Type 
* Enter your Company ID and Username 
* Add a short Description  

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_oy4jxf.png)
Then click **Submit** to create the iteration. 
 
**Generate Workbook (Reverse data from Instance into the Sheet):** 

**Step 1: Select Filter Type:** 

Once the Iteration is created, open workbook by clicking on the sheet icon. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1crzun3.png)
Navigate to **Config** sheet and select filter type, in fig below, I have selected **fetch active only** filter type so it will fetch all active records present in the instance.

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1qc45tp.png)

You can also select other filter type:

* Fetch All: will fetched all the records from the instance 
* Fetch All, except these: will fetch all records except those that are mentioned in the next column. 
* Fetch Only: will fetch the records that are mentioned in the next column. 
* Fetch Active Only: will only fetch active records. 
* Fetch In Active Only: will only fetch inactive records. 
* Fetch By Query: will only fetch records that are associated with the query 
 
Or you can use the **Dependent Functionality** by selecting **"Yes"** in Column D **"Dependent"** 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_nxo7yo.png)
When **Dependent** is set to **Yes**, records are fetched based on their parent record. This ensures that only the child records associated with the selected parent configuration are retrieved.  

**Dependency Relationships:**

**Table Transform Map** → Records are fetched using the configured filter.  
* **Transform Entry Field Map** → Records are fetched based on the related **Table Transform Map** records.


**Step 2: Start Execution:** 

Once config is set, close the workbook and back to workspace: Click on the Hamburger Menu and select **Generate Workbook**. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_dd2pke.png)

**In the pop-up window:** 
* Enter your ServiceNow instance password  
* Add any execution notes 
* Select the checkbox for Select all 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_10eecr4.png)
Then click **Confirm and Start** to start execution.

This step prepares the workbook with the basic configuration setup and backfilled the data from ServiceNow instance. 

**Step 3: Review Results** 

Once the status shows Complete, open the generated workbook. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_zgtw5e.png)
Here you can see the data is successfully backfilled into the respective sheets 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_855amd.png)
**Validation (Validate Configuration Changes from the sheet):** 

**Step 1 – Open the Generated workbook** 

Click on the sheet icon to open the generated workbook 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_qeco2l.png)
**Step 2 – Change the status to Pending**  

Navigate to the desired sheet for which you want to validate the data and change the **Processing Status** to **“Pending”** 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_85zosk.png)
**Step 3 – Start Execution (Validation)** 

Once the **Processing Status is set** to **“Pending,** close the workbook and navigate back to workspace 

Click on the hamburger menu icon and select **“Request Reprocess”** 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1vvfzmx.png)
Click on the hamburger menu icon again and this time select **“Start Validation”** 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1tbht4w.png)
**In the pop-up window:** 
* Enter your ServiceNow instance password
* Add any execution notes 
* Select the checkbox for the desired sheet 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1rj6ia4.png)
Then click **Confirm and Start** to start execution.

**Step 4: Review Results** 

Once the execution status changes to **Complete**, open the generated workbook. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_hrnmc6.png)
You will notice highlights across multiple tabs: 
* **Red Highlights** → Indicate **configuration differences** between the values currently maintained in the sheet and those available in the ServiceNow instance. These highlights help identify areas where changes have been made or where the configurations are not aligned.  
* **Green Highlights** → Indicate **matching configuration** values between the sheet and the ServiceNow instance, confirming that no configuration changes have been identified. 
 
**Automation (Configure Records using ConfigBot):** 

**Step 1: Open Generated Workbook:**

* Click on sheet icon to open generated workbook
* Navigate to the desired Sheet (**Table Transform Map**, and **Transform Entry Field Map**):  
* Create and configure the records. 

**To** **Start** **Configuration** for **Automation:**

**Step 1:** Open the generated workbook, navigate to config sheet and select “Yes” in Column B “**Maintain Update Set**” and write the name of Update set in the following column. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_aq24gu.png)
**Step 2:** Then navigate to “**Table Transform Map**”, and fill the configuration in respective rows and columns, and change the “**Processing Status**” to “**Pending**” 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_xesqy9.png)
**Step 3:** Then navigate to “**Transform Entry Field Map**”, and fill the configuration in respective rows and columns, and change the “**Processing Status**” to “**Pending**” 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ahdx7g.png)

**Note:** you can connect your recent configured **Table Transform Map** in Column G & H as highlighted in image above.

**Step 2 – Start Execution (Automation)** 

Once your configuration data is set:  
* Return to your Workspace.  
* Click the Hamburger Menu and select **Request Reprocess**. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_k47uor.png)
Click on the hamburger menu icon again and this time select **“Start Configuration”** 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_l4leer.png)
**In the pop-up window:** 
* Enter your ServiceNow instance password
* Add any execution notes 
* Select the checkbox for the desired sheet 
 ![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_ul8a97.png)
Then click **Confirm and Start** to start execution.

**Step 3: Review Results** 

Once the status shows **complete**, you can navigate to workbook and see the records are successfully configured. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1ul8mlz.png)![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_g40rag.png)

**Compare (Compare Between Two Executions):** 

**Step 1 – Should have two Generated Workbooks**   

Ensure that you have two workbooks generated.  

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1x5h3vb.png)

**Step 2 – To Start Compare Execution:** 

Click on the hamburger menu icon and select “**Request Reprocess**” 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_173nzho.png)
Click on the hamburger menu icon again and this time select “**Compare iteration**” 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_6lbo9j.png) 
**In the pop-up window:**
*  Select the iteration you want to compare against. 
* Click Confirm and Start to start the execution process. 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_g0rllb.png)
Once the status shows **complete**, open the workbook and navigate to each sheet to see the changes 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_5km3v6.png)
 ![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_1jr62tr.png)

You can notice highlights across multiple tabs: 
* **Red Highlights** – Indicate differences between the two iterations. 
* **Green Highlights** – Indicate matching values across both workbooks. 

These color-coded results allow you to instantly identify what has changed or remained consistent between the two ServiceNow instances. 

Or we can also Navigate to the “**Compare Summary**” Sheet, to find the differences 

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/b/7/43b7e9fbd033000/image_13loyaj.png)
This Sheet provides a quick and reliable way to verify data consistency between executions. Instead of manually inspecting records, you can visualize differences and matches in a structured tabular form. 

**Thank You!**