When migrating or importing data, the quality of the data can be lower than if the data was entered in your apps. The import tools will not fail if data is missing from fields. This can lead to issues when accessing imported data.
There are a number of problems that are commonly encountered when importing data:
- Users are unable to save records as the required fields are blank.
- Errors are processed due to invalid or missing data.
There are several approaches that you can take to cleanse data:
- Cleanse before import: If the data is in Excel or CSV format, you can use Excel to examine the data, correct errors, and add missing values.
- Use Power Query to import the data: Power Query has the functionality to filter records, transform data, and add or calculate missing values. Power Query is an ETL (Extract, Transform, and Load) tool.
- List data to be cleansed: Create views that list the missing values of records and let users fix the data using the forms in the app.
- Cleanse...