Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
What problem or error message are you encountering?
-Rob
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.
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;
I get no errors, it just does nothing.
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.
I suggest reviewing the script execution log to ensure these statements are actually being executed.
-Rob
If you agree you can share script execution log and we can have a look
So, it was user error. You cannot rename something that does not exist. Thanks for the help.