ONCOMPLETE TRANSFORM SCRIPT?

dheeru_1994
Tera Contributor

HII ALL 

i am new in servicnow , my need is i have to count recently inserted records in target table by using oncomplete transform map script and i want see message in import log not in system logs and can i get import set number
please guide me with examples like my target table is student  
i need code to achive this 
thanks in advance 

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@dheeru_1994 

you can query the import set table with the current set and check the state=inserted to know the count

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

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@dheeru_1994 

you can query the import set table with the current set and check the state=inserted to know the count

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

hello sir , can you help me in how we call script include via transform map ? i write a regex code where i call in transform map event script ?

@dheeru_1994 

why to call script include?

you can directly use transform script

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

i have paragraph in html in there html paragraph three links i make regex to replace all the links now my need is the regex i made i have to write in script include for that regex now i have a table in that table one field is html type in now i have make one excel sheet and in sheet there is html paragraph  all three links are there now i have to make one on before or on after transform script to call script include that when transform map run in target table field replace all links which i make pattern and replace method apply in script include how does it possible to do this