Table Manipulation Tasks
Table manipulation task Dex to manipulate the Dex data stream which can be thought of structrally as an in-memory CSV file.
Below is a list of current Dex table manipulation task with a general description of what they do.
| TASK | DESCRIPTION |
|---|---|
| Add A Column | This task will add a static column to the data. |
| Add Row Number | This task will prepend a row number column to the data. |
| Column Filter | This task will filter out or filter for the specified column names. |
| Group Columns | This task will allow one column to be grouped into several. |
| Replace All | This task will replace all occurrences of a regular expression across all rows and columns of data. |
| Select Columns | This task will allow the user to select the desired columns and the desired order of the columns. |
| Split Columns | This task will split the data table based upon the supplied specification. |
| Trim Columns | This task will trim beginning and ending whitespace from all rows and columns within the data. |