Change column Headers in export Excel/CSV?

Liyakhat2 · ‎07-15-2021

Hi Team,

We are exploring a way to change column header names while downloading a report/exporting

data through excel/CSV we are having two cases

1.can we change column headers to different names while downloading? Is this possible through a view?

2.Can we change data from the table to uppercase and download it in excel?

use case: we have a system developed in SAP they were using different columns and data formats earlier where they got data from SharePoint and share point is being replaced by ServiceNow.

palanikumar · ‎07-15-2021

Hi,

There is one option available via data base view. Follow the steps:

1) Create a database view

2) You can add only one table to database view. Add your table with some variable prefix. Remember this prefix. Refer screenshot1 below

3) Goto System Definition > Language File and create a new language file with following details

- Table = your database view created

- Label = The name you want in the export

- Plural = Plural form of label

- Element = The field in database that need to be renamed. You have to prefix the variable prefix used in database view (from step 2). I gave inc as variable prefix in database view. So, I used inc_short_description to refer short_description field. Refer screenshot2

And the output is below. You can use the Database View for export

Thank you,
Palani

View solution in original post

sndev1099 · ‎09-14-2021

@palanikumar Thank you! Got this working apart from one field. So I've joined the computer table with location and this has given me everything I need. However, I need to change location parent.parent. Any idea how I would do that? I currently only have parent not parent.parent