RenameColumns
Gives columns clearer names without touching the data. List the current names and the new names in matching order; columns you do not list keep their names. Handy for cleaning up cryptic export headers, and often necessary before a Join or Union, which match columns by name.
Inputs
| Input | Accepts | Required |
|---|---|---|
Table | Table | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
OldNames | — | Choose one or more columns from the connected table. Comma-separated list of the current column names to change (e.g. Amt,Cust_Nm). |
NewNames | — | Comma-separated list of replacement names, in the same order as OldNames; the first old name gets the first new name, and both lists must have the same number of entries. |
Example
A bank export arrives with TXN_DT, ACCT_NO, and AMT. Set OldNames to
TXN_DT,ACCT_NO,AMT and NewNames to Date,Account,Amount. The renamed table
appears as its own tab, and now lines up with your other transaction tables for
a Union.