Filter out empty rows

Help Studio
1

Hi there,

I have an excel where first row have values and the subsequent rows no values and then values in another row. How do i filter out the empty rows in a specific column?

2

Hello
there is an activity “filter datatable” which can help you in this case

image
image727×530 19.8 KB

3

Hi @mark_rajkumar1

You want to store the empty rows in a datatable which rows are empty in a specific column, then use below linq expression,

- Assign -> Output_dt = Input_dt.asenumerable.where(Function(X) String.isNullorEmpty(X("Column name").toString) andalso String.isNullorWhitespace(X("Column name").toString)).Copytodatatable()

If you want to filter the rows which doesn’t have empty in a specific column use the below linq expression,

- Assign -> Output_dt = Input_dt.asenumerable.where(Function(X) Not(String.isNullorEmpty(X("Column name").toString) andalso String.isNullorWhitespace(X("Column name").toString))).Copytodatatable()

Use the LINQ Expression based on your requirement and change the column name in the place where I mentioned Column name with in the braces.

Hope it helps!!

4

Hi @mark_rajkumar1

FilteredDT = DT.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row("ColumnName").ToString().Trim())).CopyToDataTable()

Regards,