Skip to content

Remove Empty Rows

Removes the empty rows from a DataTable.

Name Description
Columns The column indexes or column names to verify.
DataTable The input DataTable.
Mode Determines when a row should be removed. (All) means that all columns must be empty to remove the row. (Any) for any column empty and (Custom) for the user defined rules.
Operator Determines the evaluation condition for the specified columns where (And) checks if all columns are empty and (Or) checks if any of the columns are empty.
Result The output DataTable.

It can be used in 3 different ways, set by Mode property. Check the description of each on the properties table above.

Let's consider the following DataTable except for the first column which is being used here just for reference:

# (ref-only) Country (or dependency) Population (2020) Yearly Change Net Change Density (P/Km²)
1 China 1,439,323,776 5,540,090
2 India 1,380,004,385 0.99 % 464
3 United States 331,002,651 0.59 % 1,937,734 36
5 Pakistan 220,892,340 2.00 % 4,327,022 287
6 Brazil 212,559,417 0.72 % 1,509,890 25
7 Nigeria 206,139,589 5,175,990 226
  • All

    In this mode, only the row 4 will be removed because all its values is empty/null.

  • Any

    In this mode, the rows 1, 2, 4 and 7 will be removed because at least one of the columns is empty/null.

  • Custom

    When we specify this mode, we need to work with Columns and Operator properties.

    Lets say that we want consider just the columns to decide if the row should be removed or not.

    Columns = { "Yearly Change", "Density (P/Km²)" }

    The Operator says how we want to evaluate these columns:

    • And - Means that "Yearly Change" AND "Density (P/Km²)" must be empty to remove the row which in this case will remove the rows 1 and 4.

    • Or - Means that "Yearly Change" OR "Density (P/Km²)" must be empty to remove the row which in this case will remove the rows 1, 4 and 7.