Delete the extra row from excel based on actual amount

Help Activities
, ,
1

Hi team,
How to delete the row from excel if it is not macthing with actual amount column.
Like we have sum of net amount is 17,549.21. but we have given the actual amount is 3090.02.
So in this example if we remove 3rd and 4th row and then take a sum of net amount so it will give 3090.02 that is equivalent to actual amount. So how to do this calculation in UiPath. Attaching a example for reference.

image

2

Is there any additional column that can be used to identify which rows to calculate together? For example invoice number, transaction number…

3

We are checking Begin Date & End date column. Need to perform the calculation for the similar begin date & end date.

4

Hi Riya,

If you want to remove data row from datatable use - Remove Data Row, but you have to ensure use this activity in cloned datatable not in main datatable, otherwise bot will throw an error.

Second option will be use - linq query,
Step1. clone the main/ first datatable,
Step2. use foreach activity with first datatable,
Step3. inside for each use an assign with second dt=
tb.AsEnumerable()
.Where(r => r.Field(“Modul”) == value)
.CopyToDataTable()

Cheers…