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,

So if it is a data source then consider example file has 3 columns but latest file has 4 columns system will create new column automatically.

you need to have field map for this so that 4th column data is populated in some target column.

Regards

Ankur

[vickyc]

Actually my datasource is JDBC not excel file

This is an existing import set table, what about to load data in that new columns

[Ankur Bawiskar]

Hi Vicky,

You need to have field map for that. This won't be done by system since how system will know which column to map the data to.

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

[Ankur Bawiskar]

Hi Vicky,

Any update on this?

Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards

Ankur

[Ankur Bawiskar]

Hi Vicky,

Any update on this?

Regards

Ankur