Best way to combine 2 data tables on the same time

strong text

hi @Rousey_G

Welcome to the Uipath Community.

  1. If we want to merge Datatable - we can use the MergerDataTable activity : Merges the specified DataTable with the current DataTable, indicating whether to preserve changes and how to handle missing schema in the current DataTable.
  1. If we want ot Join 2 DataTables based on some Condition we use - Join dataTable activity - Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the JoinType property.