how to use not in list in filter expression in sap datasphere, give me the syntax

In SAP Datasphere, you can use the `FILTER` expression to exclude values from a list by utilizing the `NOT IN` syntax. The typical structure for using `NOT IN` within a `FILTER` expression is similar to SQL. Here is an example of how to use it: ### Syntax Example ```sql FILTER(<your_table>) WHERE <your_column> NOT IN ('value1', 'value2', 'value3') ``` ### Breakdown - **`FILTER(<your_table>)`**: This specifies the table or dataset you are filtering. - **`<your_column>`**: This is the column in the dataset that you are evaluating. - **`NOT IN ('value1', 'value2', 'value3')`**: This clause excludes rows where `<your_column>` matches any of the specified values. ### Example Suppose you have a table named `Sales` and you want to filter out the sales for regions 'North' and 'South'. Your expression would look like this: ```sql FILTER(Sales) WHERE Region NOT IN ('North', 'South') ``` This query will return all rows from the `Sales` table where the `Region` is neither 'North' nor 'South'. ### Usage Make sure that you adapt the syntax according to the specific column names and values from your dataset in SAP Datasphere that you wish to filter.