Last Updated: Mar 15, 2021
You can filter, edit the schema, toggle to query edit view, and publish the datasets in SQL Editor.
You can filter the data based on conditions using this option.
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 |
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.
Click the APPLY button. The data gets filtered in the SQL dataset based on the conditions.
Click the + icon to add multiple conditions.
You can sort the values by its occurrence in the column.