Icon

Transformer

<p>This tool can transform the input table using the following transformations: column filtering, column resorting, and column renaming.</p><p>Do not use this tool if the task is to replace one column with another, there is a dedicated ColumnReplacer tool for that.</p>

This tool can transform the input table using the following transformations: column filtering, column resorting, and column renaming.

Do not use this tool if the task is to replace one column with another, there is a dedicated ColumnReplacer tool for that.

Test data


To be used during development

Input data


Zero, one or more input data tables

Parameters


Configuration nodes: the values that can be set by the agent.

Transformer

This tool can transform the input table using the following transformations: column filtering, column resorting, and column renaming.


❗ To be copied to the workflow description

Output data


Zero, one or more output data tables

tableToTransform
Workflow Input
Data Generator
columnsToRename
String Configuration
Column renaming
0: resorting_off1: resorting_on
CASE Switch Start
Column resorting
resorting_on
Variable Expression
Workflow Output
CASE Switch End
columnsToKeep
Column Filter Configuration
0: renaming_off1: renaming_on
CASE Switch Start
keep all by default
Column Filter
renaming_on
Variable Expression
CASE Switch End
columnsToResort
String Configuration
Merge Variables

Nodes

Extensions

Links