#Part
In this part I am giving a quick overview on how to remove duplicates.
We need to finish with this step to make sure that we have accurate data.
Udemy Course :
Covid-19 ServiceNow Dashboard : https://bit.ly/2TPlJxd
Covid-19 API integration in Servicenow: https://bit.ly/3g978GF
Linkedin Integration in Servicenow : https://bit.ly/2y7yxYr
ServiceNow Web App : https://bit.ly/3dqgzz7
Duplicates Countries :
// You should replace Iran,Islamic Republic of by Iran and do exactly for the list of countries
Iran,Islamic Republic of---------Iran
Central African Republic------CAR
Congo(Brazzaville)-------Congo
Congo(Kinshasa)-------DRC
Czech Republic----------Czechia
Holy See(Vatican City State)------Vatican City
Lao PDR------Laos
Macedonia,Republic of -----North Macedonia
Palestinian Territory------Palestine
Russian Federation------Russia
Syria Arab Republic(Syria)-----Syria
Taiwan,Republic of China------Taiwan
Tanzania,United Republic of----Tanzania
United Kingdom-----UK
United States of America----USA
Venezuela(Bolivarian Republic)----Venezuela
Viet Nam-----Vietnam
Korea(south)-----S.Korea
///Delete records with empty location fied
Note:
We don't have data for China, Australia and other small islands.
