Joining 2 DataTables

Hi All,

Currently I have 2 Data Tables. Both Data Tables have the same columns and are in the same order. The first Table has 22184 rows and the second has 22183 rows. Also should note that both tables have the same data except that table 1 has 1 extra row. When I use the “Join Data Tables” activity using the Full join I end up with a Data Table that has 22196 rows. Is this correct and if so why? I thought I would end up with 22184 rows in the final table, any help would be appreciated thanks!

Hai @kahoyim
:point_down::point_down::point_down::point_down: Refer this how to use join mechanism in various situations

1 Like