Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
erieqlik
Contributor III
Contributor III

Using Sense in Cloud to rename fields, rename field not working

I have a series of tables the are a result of an API call to ServiceNow for incident data. They are all reference tables. I can mash it all together with Joins but I have a naming issue. I want to do renames to reflect the actual names of the column data.

The following will not function as I expect. Perhaps I do not understand the fundamentals of Rename Field. The "to" name is unique.

Rename Field link to cmdb_ci_link;
Rename Field link_u01 to u_category_list_link;
Rename Field link_u02 to closed_by_link;
Rename Field link_u03 to assigned_to_link;
Rename Field link_u04 to resolved_by_link;
Rename Field link_u05 to opened_by_link;
Rename Field link_u06 to sys_domain_link;
Rename Field link_u07 to caller_id_link;
Rename Field link_u08 to assignment_group_link;
Rename Field link_u09 to problem_id_link;
Rename Field link_u10 to location_link;
Rename Field link_u11 to reopened_by_link;

Suggestions?

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Please explain your issue using rename.

Are you getting errors or is it not giving you the output you expect.

Please note that the rename have to be done on fields after they have been loaded into the application.

You can only use rename into a completely new field name, not into a field name that already exists in the data model.

View solution in original post

8 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What problem or error message are you encountering?

-Rob

Vegar
MVP
MVP

Please explain your issue using rename.

Are you getting errors or is it not giving you the output you expect.

Please note that the rename have to be done on fields after they have been loaded into the application.

You can only use rename into a completely new field name, not into a field name that already exists in the data model.

diegozecchini
Specialist
Specialist

Hi!
what if renaming directly within the Load statement than using Rename Field after the load?

Example :

Table1:
Load
link as cmdb_ci_link,
[..]
link_u11 as reopened_by_link
From ServiceNowAPI;

erieqlik
Contributor III
Contributor III
Author

I get no errors, it just does nothing.

erieqlik
Contributor III
Contributor III
Author

I want to rename columns to more appropriate names.

They exist. 

The can be in the same table or different tables.

They are all unique.

I get no error, the action does nothing.

 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I suggest reviewing the script execution log to ensure these statements are actually being executed. 

-Rob

diegozecchini
Specialist
Specialist

If you agree you can share script execution log and we can have a look

erieqlik
Contributor III
Contributor III
Author

So, it was user error. You cannot rename something that does not exist. Thanks for the help.