How to delete unwanted rows

Help Activities
,
1

Hi All,

i want to delete unwanted row from excel after extarcting.
image
i have configured below, but not working.

image
image807Ă—571 13.3 KB

it is still having empty and unprocessed invoice Totals.
how to delete that.
Thanks
Rakesh

2

Hi @RAKESH_KUMAR_Tiwari ,

Could you Double Check the Column values if there are spaces in it ? Also, The Configuration done keeps only the non-empty rows and it will not remove the Unprocessed Invoice Totals row.

Maybe you would also need to configure it in the below way :
image

Let us know if there are spaces in the column values, we could then switch to a Linq Expression to reduce the number of steps.

1 Like
3

Hi @RAKESH_KUMAR_Tiwari

Here is another approach.

You use this query in the assign activity to achieve this:

dt = dt.AsEnumerable.SkipWhile(Function(row) row(0).ToString.Trim.Equals(String.Empty) OR row(0).ToString.Trim.Equals(“Unprocessed Invoice Totals”)).CopyToDataTable

Hope this helps,
Best Regards.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.