Transform Map- Data is not inserted or updated in the Target table

Romi Kumari
Tera Expert

‎04-07-2020 03:42 AM

Hello I am working on Data Source and while doing Transform Map I am using destination table as one of the User Created Table. I have mapped source and target table fields properly with same variable Type, even data is getting imported properly. But while running the transform map no record is getting inserted or updated. Do have any idea on this?

Labels:
0 Helpfuls

Ankur Bawiskar
Tera Patron

‎04-07-2020 04:19 AM

Hi,

Few things you can check

1) check the import set table table whether data is present in this table or not

2) check the import set record; how many inserts, ignored, updated

3) please share screenshot

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Romi Kumari
Tera Expert
In response to Ankur Bawiskar

‎04-07-2020 04:33 AM

1. Yes I have checked records are getting updated in the Import set table.

2. 10 inserted, 0 updated, 0 ignored.

3. I have attached screenshot

Preview file
174 KB
0 Helpfuls

Romi Kumari
Tera Expert
In response to Romi Kumari

‎04-07-2020 04:47 AM

I have attached the details

0 Helpfuls

Ankur Bawiskar
Tera Patron
In response to Romi Kumari

‎04-07-2020 04:58 AM

Hi,

you need to run the transform map; the screenshot says the 10 records inserted into import set table

once you click the Run transform and select the transform map it would load into target table

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader