What are the ways to keep data unique in Import set other than Coalesce ?

[Chandramouli2]

What are the ways to keep data unique in Import set other than Coalesce ?

[Harsh Vardhan]

the best way would be use "Coalesce" in your transform map. 

or you can also do the field mapping by script , so here you have to use onBefore transform map script, and you will write glide record to check if the source data already available in service-now target table or not then allow to create the record or update the record in target table, but this would be lengthy process and huge amount of code you will have to write. 

i would suggest go with "Coalesce" , that's the best approach.  

refer the below article for more details about "Coalesce".

https://www.servicenowelite.com/blog/2014/3/30/coalesce-methods

[Harsh Vardhan]

if i answered your query kindly mark it has correct and close this thread

[Ashutosh Munot1 · Accepted solution]

Hi, I did it using onbefore transform script. I had coalesce depending upon many condition or you can say it was complex requirements. If condition was satisfied then i used to insert the record and if not then ignore flag was marked true. Updation was also doing in script include called from onbefore script. Thanks Ashutosh

[Harsh Vardhan]

my answer did not clear your doubt ? if yes kindly mark my answer as correct.