how to get duplicate rows as a datatable（Dt_C） From （Dt_A）, and remove all duplicate rows to generate（ Dt_B） without using for each?
※because in the real world, Dt_A have billions of rows…
The image is as follows.
column" Value1" have duplicate rows（row2, row3）, cut out row2, row3 to create Dt_C. and remove all duplicate rows from Dt_A.
※ I don’t want to keep the first occurrence. so I can’t just use remove duplicate rows activity to solve this.