Filtered, deleted and summed from Excel,

Hi, I hope you can help me with this problem.

I have an excel where I want to remove the duplicates based on column “B” and adding the numbers from column “D”

Column “A” is the day of the month, so knowing this an example would be the following

image

In this data I would have the following output

DAY , ID , SUM
31 , 5266 , 50422.19
31 , 6178 , 1812.26

now the id will be repeated many times but the day will be different

image

output

DAY , ID , SUM
30 , 5266 , 37977.24

then the complete output of my file would be the following

DAY , ID , SUM
31 , 5266 , 50422.19
31 , 6178 , 1812.26
30 , 5266 , 37977.24

I hope you can help me, or give me some advice on how to search or what activity to use for this purpose

Hi @Ivan_torres_oliva Try with Filter Data table activity or use syntax DT.Defaultview() function.

@Ivan_torres_oliva

You want unique records rights. Then try below expression.

      uniqueDT = yourDT.DefaultView.ToTable(True,"DAY","ID","SUM").CopyToDataTable

Could you explain more details, I’m new to this

my file has no headers