Sameer_Chandragiri

Tech Tip: DataMaker - Importing data from two Excel/CSV files successivlely to a single data pool

Discussion created by Sameer_Chandragiri Employee on Sep 29, 2015
Latest reply on Feb 28, 2017 by AnitaThakur82306825

Suppose you have a use case where you imported data from an Excel file to a data pool and later you have additional data in another Excel file (with the same format) that you would like to append to the same data pool. The steps you would follow are:

 

1. Rename the second Excel file (with additional data) so that the file name matches the first Excel file that you had successfully registered and imported.

2. Register the second Excel file with the same project. This time on the registration screen, the workbook name should match the first Excel sheet that you had registered and imported from previously.

3. Also, on the registration screen, make sure “Import Any Data” is checked and “Register” is unchecked. Then click the “Register/Import” button.


DM_Register_second_Excel.jpg

4. This will append the additional records to the same data pool.

 

Note that if your data exists in a CSV file, you should be able to right-click on the data pool that has the initial data imported, and then click ‘Import External File Data’ and point to the CSV file.

In this case, however, it is important that your CSV file does not contain the “Header” row with column names. Else, that will also get imported as a record in your Data pool.

Outcomes