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