Can we create field dynamically in the target table while importing data through attachment?

[VasaviSindG]

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 .

For Example-

If target table has only first name, last name, user id, email. But the attachment has other field called phone number , then how to create that phone number field dynamically in the target table while importing data ?

[Najmuddin Mohd]

Hello @VasaviSindG ,
Creating a field is just adding a record in the sys_dictionary.LIST table.

But, when you know the data, you map the fields and you know that there is one more extra column and you create a field before importing. Not at all recommended to create an extra field dynamically. Review the Input data and map it accordingly.

Check are there any OOB fields, which you are not using and can utilise it for phone number as said in the example.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.R
Regards,
Najmuddin.

[VasaviSindG]

Actually , that is just example that i have given. But the question is "create field dynamically in the target table while importing data through attachment?" Is that possible?

[Dr Atul G- LNG]

NO, mate not possible.