Can I Change a COlumn Heading in an Export Set/Export Definition?

johnfeist
Mega Sage
Mega Sage

I have an export set that runs on a schedule and is sent from the mid server to one of our service providers.  Because of the number of columns and the data within, some of the columns have redundant names.  This is occurring in columns that dot walk against tables like sys_user where I many need to include the Caller's manager and the Assigned To's manager.

The recipient has started whining about their input tool not being able to deal with redundant column names.

Is there a way that I can relabel some columns as part of creating the export set or do I need to create a view with the renamed columns and then do the export from there?

Thank you for any information you can provide.

:{)

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster
1 ACCEPTED SOLUTION

sachin_namjoshi
Kilo Patron
Kilo Patron

You can use column names in export set headers so that you will get unique names.

Please see below

 

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/exporting-data/concept/export-set-fields-display-value-header.html

 

Regards,

Sachin

View solution in original post

2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

You can use column names in export set headers so that you will get unique names.

Please see below

 

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/exporting-data/concept/export-set-fields-display-value-header.html

 

Regards,

Sachin

Thank you Sachin,

Ideally what I would like is to be able to change the column "label" e.g. from Resolved By to Who Fixed It.  From what I'm seeing, that isn't possible.  Using column names looks to give me what I can live with.

:{)

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster