Search

Filter Data in CSV Dataset

Articles

Click the Image description icon against each column to sort or filter the data.

Image description

  1. Ascending: Sorts the data in ascending order.
  2. Descending: Sorts the data in descending order.
  3. Filter by Value: Filters the data based on conditions added.

    1. Select the column name in the first drop-down. 
    2. Select a condition to filter in the second drop-down. Image description
      The available conditions are:

      Condition Result
      in Displays the values that exist within the specified range.
      nin Displays the values that do not exist within the specified range.
      eq Displays the values that are equal to the specified value.
      ne Displays the values that are not equal to the specified value.
      empty Displays the empty values.
      nempty Displays the values that are not empty.
      contains Displays the values that have the specified value as a part of them.
      ncontains Displays the values that do not have the specified value as a part of them.
      starts Displays the values that start with the specified value.
      nstarts Displays the values that do not start with the specified value.
      ends Displays the values that end with the specified value.
      nends Displays the values that do not end with the specified value.
    3. To add values for the filter condition, click the Image description icon and select from the values listed. Image description

      Select FlightName from first drop-down, in from the second drop-down and the values AirAsia and Indigo from the third drop-down.
      Image description

    4. Click the APPLY button. The data gets filtered in the column based on the conditions.

    5. Click the + icon to add multiple conditions. Image description

      You can sort the values by its occurrence in the column.

Did you find what you were looking for?