function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
John PatersonJohn Paterson 

Data Management - Importing Data Challenge

In the "Preparing for Data Import" topic we are taught to "Clean up the import file for accuracy and consistency. This involves updating the data to remove duplicates..."
In the import file for the challenge though there is an obvious duplicate John Dodge and Jack Dodge with the same mobile number. (Jack is a common diminutive / nick name for John). If you remove the duplicate though you fail the challenge. Leave the duplicate in and you pass. There also doesn't seem to be any need to remove formatting from phone numbers as shown in the video. Don't mean to be pedantic, but maybe a good idea to remove the duplicate so we don't have to spend time wondering whether to remove it or not. Or maybe in the instructions for the challenge, just say "No need to clean the data prior to importing" or something.
Cheers
William TranWilliam Tran
Because they check your answer automatically, the challenge guidelines are sometimes absolute, so going above and beyond that may cause you to fail the challenge.  As for as removing duplicates, Jack and John are 2 different names; like Will, Wiliam, Bill, etc are different names even if they have the same phone and/or email, you can't remove them just because of an assumption, plus how would you know which one to remove unless you created both records and know exactly what your client name should be.  If that was the case you should not have created both in the first place.

Thx