Need some help

Help
1

Hi all,

I wish to merge 2 datatables with 2 same column names (the tables only have 2 columns). I used the ‘Merge Datatable’ activity, however the result of the merged table is not what I wanted. Instead of merging table 2 data below table 1, it placed table 2 data on the right of table 1 data (creating 2 more columns)

What went wrong??

2

@WillieBoykin

Welcome to the UIpath Community.

  1. First read both data from Excel using Read Range Activity separately and will give you output as dataTable and say ‘DT1’ and ‘DT2’ respectively.

Then try below expression to merge:

DT1.Merge(DT2)

And also make sure Column names should be same in both files and also it is case sensitive.

3

Hi @WillieBoykin

Use invoke method to merge

Thanks
Ashwin.S