Remove Grouped Sum

Help Forum
1

Hi experts, I have two datatables, one is a pivot data table(DataTable A) containing the group which sum is 1. The other is DataTable B containing all data. I need to remove the rows which sum is 1 from Datatable B and write it to excel.Please assist

2

Hi,

Try using Filter Datatable activity to remove the specific rows.

3

Thanks for your PM. May we ask you to share some sample input data along with a sample of the expected result with us?

4

This is DT A
Number AMT
AX100 1
B4200 32
CQ300 43
DW400 5
ES500 2
FW600 4
JZ700 1
KS800 1
LA900 54

Wile DT b is
image

5

I need to remove matching rows with amt from DT b and store as a datatable but using the pivot DT A and number column as a reference

6

In otherwords, where column number in dt A match in dt b remove the row in dt B and store as a datable

7

Are you there

8

@stanstilo
is it still open or done?

9

Hi @ppr, this is still open, please assist