Need fields to add in the import set table

[vickyc]

Hi,

I had created import set in service now which i created table and load data through JDBC connection.

Now in the source new fields are added so those new fields i need to add in my import set table.

Below question i have:-

1) while adding new fields in the existing fields it will impact the existing the structure and data of the table.

2) Do i need to clean up completely   all data from the table then to load data completely to see the data in the new fields

3) Or is there a way to load data only in new columns not on the complete table.

Thanks

[Ankur Bawiskar]

Hi Vicky,

The columns will be created automatically if they don't match the existing columns present in import set table.
One thing you need to do is the field map for those new columns so that you can define which target column the data should go which is coming in new columns.

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

Thanks

Ankur

[vickyc]

Thanks for the update.

Could you confirm how to add new fields in the existing import set table and how to load data in those new columns.

Thanks

[Ankur Bawiskar]

Hi Vicky,

The system will create new fields automatically if the format is not matching existing. But if you want to create new fields on your own then the steps are same as normal table i.e. through dictionary create new column for this table. Have field map for the newly created column to put the value in target table record.

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

Thanks

Ankur

[vickyc]

Hi,

When you say automatically add in the import set , so do we need to do refresh the table?

or any other way to add those fields automatically

Thanks