Drop Column
Drop Column
Section titled “Drop Column”Type: drop-column · Package: DataTable Activities v1.0.0 · Output: DataTable
Removes one or more columns from a DataTable and returns a new table without them. Useful for keeping only the relevant data before writing a report, or for removing internal/temporary columns.
How it works
Section titled “How it works”Removes the columns indicated in columns (a list of names) from the table. Returns a new table; the original does not change.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
table | expression | The DataTable to modify. |
columns | arreglo | List of column names to delete, e.g. ["Interno", "Temp"]. |
Optional parameters
Section titled “Optional parameters”Ninguno.
Output
Section titled “Output”Returns a DataTable without the indicated columns.
Example
Section titled “Example”Remove auxiliary columns before exporting:
Drop Column table = = datos columns = = arr("IdInterno", "Hash") → output: limpioWrite Excel Sheet path = "C:/out/export.xlsx" data = = limpioRelated activities
Section titled “Related activities”- Rename Column — rename instead of delete.
- Add Column — add a calculated column.