Task: Combine 37 comma separated values files (.CSV) into one
Challenges:
- Cross-reference each component in the CSV files with a Master list of components
- Remove duplicates after the merge
- Generate two reports: a component list; a missing components list
Since the client just wanted two clean files, I was free to use my software to automate the merge. (Otherwise, I would have had to write a macro for him to be able to it on his computer.)
Click on a project link for more details about that specific project.