Read and add data excel

[sereganator (Sergey)]

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:

Sample1.xlsx (8.1 KB)
Sample2.xlsx (8.2 KB)

[doceluch]

hi @sereganator

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

[ghazanfar (Ghazanfar Ali)]

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

[ppr (Peter | MVP)]

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

[Ronald_Morton]

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

[sereganator (Sergey)]

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

[sereganator (Sergey)]

Thanks for your help.