- Joined
- Dec 14, 2007
- Messages
- 6
- Reaction score
- 0
Hello,
I need to create a .CSV file by doing a comparison between two other CSV files.
Headers from file #1 (HRFILE.CSV)
givenName phoneNumber mobile EmployeeID
Headers from file #2 (ADEXPORT.CSV)
CN EmployeeID
The HRFILE.CSV file provides a list of user accounts to modify while the ADEXPORT.CSV file is the complete list of all users in the organization. I need to write a formula which will take all users in the HRFILE.CSV and match them to a corresponding user in the ADEXPORT.CSV file. The output should be in the form of a new file called IMPORT.CSV which should contain the following information:
Headers from file #3 IMPORT.CSV
CN givenName phoneNumber mobile
It seems rather straight forward but I've never used an Excel spreadsheet to perform a comparison before. Can anyone assist with this?
I need to create a .CSV file by doing a comparison between two other CSV files.
Headers from file #1 (HRFILE.CSV)
givenName phoneNumber mobile EmployeeID
Headers from file #2 (ADEXPORT.CSV)
CN EmployeeID
The HRFILE.CSV file provides a list of user accounts to modify while the ADEXPORT.CSV file is the complete list of all users in the organization. I need to write a formula which will take all users in the HRFILE.CSV and match them to a corresponding user in the ADEXPORT.CSV file. The output should be in the form of a new file called IMPORT.CSV which should contain the following information:
Headers from file #3 IMPORT.CSV
CN givenName phoneNumber mobile
It seems rather straight forward but I've never used an Excel spreadsheet to perform a comparison before. Can anyone assist with this?