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

Filter

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

1. Click the 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 icon and select from the values listed.

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

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.
   

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