Need help for transform map

[Teja3]

I have requirement

We are enhancing some table (test) and hence need to modify the excel template with in catalog item(test2 )to accommodate newly created columns.

So basically there is table called test

Which was recently updated with new columns

And there is a bulk upload of data which can be done on this table using some catalog item called test 2.

So need to accommodate newly added fields to this table 

(In the excel we have many no of sheets these sheets have different table names in that one sheet (table) need to modify)

Please Anyone let me know how can I do this.

Thanks in advance

[PatrickMutchler]

@Teja3,

If I am understanding you correctly, you have added new columns to a table and now are looking to populate the rows within those new columns via a catalog item.  The first step to this would be to make sure that the spreadsheet contains the new columns.  You could manually add those columns to the spreadsheet, or follow these steps to have ServiceNow do it for you.

1. From your table list view, right click and select Import.
2. Click on 'Create Excel template' to generate an Excel template with all of the columns from the table.
3. If some of the columns are not used, you can remove any that you don't need from the spreadsheet to clean things up a bit.

Once you have the columns added to the spreadsheet, you will then want to add them to the existing transform map.  If you created a new template following the steps above, make sure that the column names in the spreadsheet match the transform map.

As always, perform this in a sub-Production instance, such as a test instance, to ensure that you aren't inadvertently overwriting Production data.  Let me know if you have any issues.