Read and add data excel

Hello everyone!
Please tell me how to add data from the excel file sample1 to the file sample2, so that the data is added in accordance with the names of the columns. Thanks.
Exapmle:
Before (sample2):


After:
image
Sample1.xlsx (8.1 KB)
Sample2.xlsx (8.2 KB)

hi @sereganator

try this video Uipath Merge Data Table (COMPLETE TUTORIAL Addwithkey Alternative) - YouTube it should help you :slight_smile:

Is the schema of both excel file is same?
if same then first read both excel file. you can simply use merge datatable activity with add property like below


in this case destination datatable has complete data you can dump this datatable into excel to get required result.

Hope this will work

1 Like

@sereganator
find starter help here:
MergeDataTable_IncompleteStructure.xaml (8.4 KB)

1 Like

What can I do if I saw Sorry, No Clipboard Allowed Manipulations error

The structure of the database is different, so I will use the “Ignore” option, thanks for your help anyway.

Thanks for your help.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.