Problem in importing import set when adding new column.

[shivam6]

When I am adding a new column in the import set and try to import it, I cannot see the new column in the created table in service now.

Can anyone tell me how it can be resolved?

[srinivasthelu]

Hi Shivam,

Can you please elaborate?

If you wanted to create new column in the table, you can do that by following steps.

Left nav menu-> Tables->filter the table->open table record-> add new column in the Table Columns embedded list

Thanks

Srinivas

[Pradeep Sharma]

Hi Shivam,

Please check the field mappings on the transformation map. In most of the cases field mapping is missing.

Please let us know if you are blocked.

[Tanaji Patil]

Hi Shivam,

First you should create that field on the table and then use your import set to import the data for it.

Thanks,

Tanaji

[shivam6]

I am trying to import a new file which has 6 columns. But I want to use and existing import set table which has only 5 columns.

It is written in ServiceNow wiki( http://wiki.servicenow.com/index.php?title=Importing_Data_Using_Import_Sets) that "When an existing Import Set table is chosen the table columns are added when the incoming source of data contains fields/columns that do not exist."

New column is is visible in the dictionary structure of import set table but when I load the table, it doesnt show the loaded data in the import set table of the new column.

The column is getting created but the data is not loaded while loading.

Please help in this regard.