Best way to combine 2 data tables on the same time

Learning Hub
1

strong text

2

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.

–
Mukesh

3

Is there any way we can avoid repetitive columns if two datatables have some similar columns while using join datatables activity?

4

Hi @Sailu

Welcome to UiPath Forum.

For this scenario, you have to delete the duplicate columns before joining the datatables.

I have attached xaml file for your reference. Please try this and let me know whether it meet’s your expectation.

Duplicate_Column.xaml (10.6 KB)

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

5

Thank you Vignesh. It works this way.