can we dynamically create column in table when we are loading data through attachment excel format

[Onkie]

The computer processing team needs to automate the process of inputting computer device data. As a ServiceNow developer, the objective is to create an automated solution to simplify this data entry process. This solution should handle dynamic data inputs, including new columns or fields that may be added over time, ensuring accuracy in data .
so basically whenever user is uploading an attachment in the catalog item, it should create records in the target table.
but if there are any new fields/columns it should automatically map it and add the new column data into the target table.
Is it even possible to do this?

[maheshkhatal]

@Onkie I don't think it is possible to automatically do both creation and mapping simultaneously as it might defeat the the purpose of data loading as pre-requisite is you know which field is mapped to what incoming field.

Mark my response as helpful if it helped clear your doubt.

Thank you,

Mahesh.

[Dr Atul G- LNG · Accepted solution]

No @Onkie 

It's not possible because to create a field in ServiceNow, the data type is required. The system needs to know what type of data is needed for the field. Additionally, if someone adds a space at the end of a field name in an Excel sheet while creating a field, it will be treated as a new field, even though the field already exists. This can cause inconsistencies and errors.

[Ankur Bawiskar]

@Onkie 

adding fields via script is not recommended and not a best practice.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Onkie 

Thank you for marking my response as helpful.

As per new community features you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.