Is load data work "dl_u_assigment" Table ?

SD_Chandan · 3 weeks ago

Hi Community,

When i am creating manual record in dl_u_assignment table it is properly setting fields but when i load my data it is not working properly can you anyone help me in properly Loading data in table or any small suggestion is appreciated.

Thanks in advance ...!

Thank you
Chandan

Ankur Bawiskar · 3 weeks ago

@SD_Chandan
is data getting inserted into staging table?

if yes then transformation should kick off.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

Bhuvan · 3 weeks ago

@SD_Chandan

Can you check the choice fields are available and you are using actual value and not the label ?

I tried this in my PDI and it works fine.

In the choice action, use ignore so that it does not create new option in the sys_choice table. If you use choice create [default], it does not work and it expects the script to handle the creation.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

View solution in original post

SD_Chandan · 3 weeks ago

Hi @Ankur Bawiskar ,
I am directly mapping still it is not working

Thank you
Chandan

Ankur Bawiskar · 3 weeks ago

@SD_Chandan
is data getting inserted into staging table?

if yes then transformation should kick off.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

SD_Chandan · 3 weeks ago

Hi @Ankur Bawiskar ,

Now it is working

Thank you
Chandan

VikMach · 3 weeks ago

@SD_Chandan, I have provided an alternate method in the link below to upload or insert the data.
Use this alternate method it does the same thing. It is short and easy. Just change the 2nd Step from "Update" to "Insert".

https://www.servicenow.com/community/developer-forum/error-trying-to-update-records-in-custom-table-...

Let me know if it worked.

Regards,
Vikas K