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 Tutorial | 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 Preuss)]

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

[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.