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.
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.
When we are registering the CSV from TDod portal, do we have any option to import data on same DP.
I do not know if there is a way to do this through the TDM portal.
What I would suggest to do is to follow the above procedure through Datamaker, and then continue using the project/generator from the portal.
Does that help?
We have activity to load a csv to be loaded in same table ( only diffential information should be loaded).
Does TDM support automating this activity as weekly job instead of manually uploading csv every week.