topic Re: Using Sense in Cloud to rename fields, rename field not working in App Development

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

erieqlik — Mon, 13 Jan 2025 22:06:47 GMT

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?

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

rwunderlich — Tue, 14 Jan 2025 01:29:06 GMT

What problem or error message are you encountering?

-Rob

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

Vegar — Tue, 14 Jan 2025 06:13:16 GMT

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.

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

diegozecchini — Tue, 14 Jan 2025 08:46:33 GMT

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;

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

erieqlik — Tue, 14 Jan 2025 14:16:58 GMT

I get no errors, it just does nothing.

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

erieqlik — Tue, 14 Jan 2025 14:18:36 GMT

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.

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

rwunderlich — Tue, 14 Jan 2025 16:29:46 GMT

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

-Rob

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

diegozecchini — Wed, 15 Jan 2025 07:09:07 GMT

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

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

erieqlik — Wed, 15 Jan 2025 19:51:38 GMT

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