Merge CSV Files into One CSV File
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.)
Word Table to Excel Columns![]() | Merge 37 CSV Files Into One![]() |
Watch Folders![]() | Employee Training Database![]() |
![]() |