Load data to a field with brackets/parentheses in the column label

[krohan]

I have a field on cmdb_ci_server . Column label is 'Operating System (Legacy)' and column name is 'os' 

On the import table I have 'Operating System (Legacy)' and column name is 'u_operating_system_legacy'.

Transform map and Feild mapping is in place.

Also, I have a load template with the corresponding column header being  'Operating System (Legacy)'.

Issue - The value is not loaded in the import table when i load the data.

But when I remove the parentheses in the load sheet (i.e., 'Operating System Legacy')  value is loaded. But, I want the column label on the load sheet to be  'Operating System (Legacy)'. Is there a solution?

[Ankur Bawiskar]

Hi Rohan,

There should not be an issue. Till the point the column label from table matches with excel column header it should not be an issue.

can you share the screenshot for the excel file and the import set table.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[krohan]

Its actually the column name that has to match with load sheet header if the attribute import_attribute_name is not defined.

As per my experiments. 

[krohan · Accepted solution]

Got my solution.. The brackets cause the problem.

Only adding property attribute import_attribute_name=Operating System (legacy) to dictionary entry helped.

Servicenow matches load sheet field label to the one defined in the attribute 'import_attribute_name'