Search

Filter the data in SQL dataset

Articles

You can filter, edit the schema, toggle to query edit view, and publish the datasets in SQL Editor.

Image description

Filter

You can filter the data based on conditions using this option.

  1. Click the Image description icon. A Filter popup window opens to define the filter conditions.
  2. Select the column name in the first drop-down. 
  3. Select a condition to filter in the second drop-down. The available options 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 values that are empty. 
    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
  4. To add values for the filter condition, click the Image description icon and select from the values listed. Image description

    Select WarehouseId from first drop-down, in from the second drop-down and the values MFM65MBM1IA and UDU09DUB2SK from the third drop-down. Image description

  5. Click the APPLY button. The data gets filtered in the SQL dataset based on the conditions.

  6. 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?