Transform Using SQL
Description
This activity transforms the data from previous activities based on a user-specified SQL query. The transformation allows users to filter, aggregate, and manipulate data using SQL syntax.
Input
Data only
Output
Transformed data
Configuration Fields
Query The SQL query used to transform the data. The query should be structured based on the available columns from the previous activity.
Sample Input
| Column1 | Column2 | Column3 |
|---|---|---|
| A | 50 | 120 |
| B | 30 | 90 |
| A | 20 | 150 |
| B | 40 | 110 |
| C | 25 | 130 |
Sample Configuration
Sample Output
| Column1 | Total |
|---|---|
| A | 70 |
| B | 40 |
| C | 25 |