How to: Clean Up and Process Data
In some cases, you may want to clean up customer data and process it before you apply it to the database. To do that, you can customize report 8621 to fix issues, such as:
Convert dates and decimals to the format required by the regional settings on a user's computer.
Remove leading/trailing spaces or special characters.
After you modify the batch job, use the following procedure to process the data.
To clean up and process data before applying data
Open the configuration package for the company.
On the Tables FastTab, choose Functions, and then choose Process Data.
To apply the mapping that you have set up, on the Tables FastTab, choose Functions group, and then choose Apply Data.
See Also
Tasks
How to: Map Customer Data
How to: Apply Customer Data