how to use not in list filter in sap datasphere, give me the syntax
In SAP Datasphere, you can filter data using a SQL-like syntax. If you want to filter out records that are not in a specific list, you can use the `NOT IN` operator in your query.
Here is the general syntax for using `NOT IN` to filter results in SAP Datasphere:
```sql
SELECT *
FROM your_table_name
WHERE your_column_name NOT IN (value1, value2, value3, ...);
```
### Example
Suppose you have a table named `Employees` and you want to select all employees who are **not** in the departments `HR`, `IT`, and `Sales`. Your SQL query would look like this:
```sql
SELECT *
FROM Employees
WHERE Department NOT IN ('HR', 'IT', 'Sales');
```
### Key Points
- Replace `your_table_name` with the actual name of your table.
- Replace `your_column_name` with the actual name of the column you want to filter on.
- List the values you want to exclude within the parentheses, separated by commas.
By using the `NOT IN` statement, you can effectively filter out unwanted records, tailoring your data selection to your specific needs in SAP Datasphere.