Data Table SQL Filter
Filters a data table using a query based on SQL syntax.
Input
| Name | Required | Description |
|---|---|---|
| Table | Variable holding the table. | |
| Distinct | If true, the rows selected will be distinct. Duplicate rows will be filtered out. | |
| Filter | Filter rows according to the syntax from SQL's WHERE clause e.g. Col1 = 'foo' AND Col2 = 'bar'. | |
| Sort | Column and sort direction according to the syntax from SQL's ORDER BY clause e.g. Col ASC, Col DESC, etc. |
Output
Data Table The filtered data table.