Delete rows given a condition

Hello everyone, how could I delete the rows of a datatable that from column K to S have no data or have 0
That is, for this example I need to delete the rows from 2 to 7

Hi @Juan_Esteban_Valencia

Have you tried filter datatable activity for this…


just use the below activity in excel scope

list(datarow)=InputDataTable.AsEnumerable.Where(Function(r) r(“column_name”) IsNot Nothing AndAlso Microsoft.VisualBasic.Information.IsNumeric(r(“column_name”).toString) )).toList

then write it using invoke method
please share excel …

Thank you very much, I attach the excel file (this is summarized since the file I work with has 500 records)
PruebaNal.xlsx (13.9 KB)

how many records you want to del i mean range

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