This component allows users to perform SQL-based operations on the specified datatable. By using SQL queries, users can filter, sort, join, and transform datatable data efficiently without modifying the underlying data source directly, enabling advanced data manipulation within workflows.
Parameters
Parameter
Description
Datatable
Specifies the source DataTable on which the SQL query will be executed.
SQL Query
Defines the SQL statement used to query and manipulate the DataTable data. The query can be used to select, filter, sort, aggregate, or transform rows and columns within the DataTable.