function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Santosha InguvaSantosha Inguva 

data import using import wizard

User-added image

Okay I need some help here. Is this data clean? Do I need to create objects for all 8 columns and new fields? What i should select for ID - External or salesforce while importing? Are there any errors or ambiguity in this data that need to be cleaned before importing?
Best Answer chosen by Santosha Inguva
Ajvad AjuAjvad Aju
Hi Santosha,

1. Yes this data is clean. which means no duplicate records are exist. Clean data means trustworthy data, and trustworthy data is what will ensure user adoption at your organization.
2. If you want to import these eight columns to your org, and currently you have no object for this, then create a custom object with these 8 fields and import this data to the created object using data import wizard.
3. You can make any unique fields as external-ID. Here stockCode is unique, so you make it as external-ID and through that you can match your data with existing data then avoid duplication related issues while data importing.
4.If the data is clean and complete then there will be no error or ambiguity while importing.
  • Cleaned data is Accurate
  • Usability
  • Credibility
  • Adoption

You can Refer through these links
https://help.salesforce.com/articleView?id=faq_import_general_update_with_import_wizard.htm&type=5
http://salesforce.vidyard.com/watch/LP7p0HXd1THQuCmpDCSKMA


Regards
Ajvad Aju
 

All Answers

Ajvad AjuAjvad Aju
Hi Santosha,

1. Yes this data is clean. which means no duplicate records are exist. Clean data means trustworthy data, and trustworthy data is what will ensure user adoption at your organization.
2. If you want to import these eight columns to your org, and currently you have no object for this, then create a custom object with these 8 fields and import this data to the created object using data import wizard.
3. You can make any unique fields as external-ID. Here stockCode is unique, so you make it as external-ID and through that you can match your data with existing data then avoid duplication related issues while data importing.
4.If the data is clean and complete then there will be no error or ambiguity while importing.
  • Cleaned data is Accurate
  • Usability
  • Credibility
  • Adoption

You can Refer through these links
https://help.salesforce.com/articleView?id=faq_import_general_update_with_import_wizard.htm&type=5
http://salesforce.vidyard.com/watch/LP7p0HXd1THQuCmpDCSKMA


Regards
Ajvad Aju
 
This was selected as the best answer
Santosha InguvaSantosha Inguva
Appreciate your help.. THank you Ajvad Aju