How to remove duplicate values in a table?

Itay Goldshtein
Tera Contributor

‎08-09-2023 10:46 PM

Hi everyone and thanks in advance for the help,

I had a table with 1247 rows and I wanted to add another 43, I did 'import'---> 'update' ---> 'create excel template' ---> 'choose file' (I chose a file in Excel with the old and new values I added) ---> 'upload'.
Now unfortunately the values that appeared in the table before are duplicated. How do I fix it?

Here are the pictures for illustration:

ItayGoldshtein_0-1691646029067.png

ItayGoldshtein_1-1691646187790.pngItayGoldshtein_2-1691646289332.png

 

Tanks,

Itay

0 Helpfuls
  • 420 Views
3 REPLIES 3

Community Alums
Not applicable

‎08-09-2023 10:50 PM

Hi @Itay Goldshtein ,

Please make coalesce as "true" for a field in the transform map. coalesce will prevent to create duplicate records.

Learn more from the Article : https://www.servicenow.com/community/now-platform-articles/import-transform-learning-path/ta-p/23069...

 

0 Helpfuls

Itay Goldshtein
Tera Contributor
In response to Community Alums

‎08-09-2023 11:48 PM

Hi @Community Alums , thank you for the answer. I opened the article you sent and didn't find the instructions how to do this 'coalesce' - true. I fount only the text that emphasized the importance of it. see the picture: 

ItayGoldshtein_0-1691650005885.png

 

0 Helpfuls

Itay Goldshtein
Tera Contributor
In response to Community Alums

‎08-10-2023 01:28 AM

ItayGoldshtein_2-1691656058309.png

 

 

ItayGoldshtein_1-1691655860457.png

@Community Alums , These are the messages I received when I changed the 'coalesce' to "true"

 

0 Helpfuls