Delete blank row after last entries in excel

Help
,
1

Hello,
I have an excel like this

image
image572×642 16.6 KB

There is a problem when I try to upload the file to the system, the system gave an error because there is a blank row (but there is a value (row 12 and so on)) so the system show error

Is there any way to delete the row below the last package id (A11)?

2

Hello @Fauzan_Marantama,

you can try this two approach.

First approach is to use query where
first clone the datatable using assign activity
where datatable = datatable.clone
in second assign
datatable = datatable.select(“columnname <> ‘’”).CopyToDataTable()

2nd approach is to use filter datatable.

image

here in column give your column name.

3

I’m interested on the 2nd approach

if Im use filter datatable to delete the empty row, how can i keep the second row? because the 2nd row are needed despite it’s a blank row