ExtractColumn
Pulls one column out of a table as a list of values, ready to feed calculation nodes. NPV, IRR, MovingAverage, Aggregate, and the rest expect a series of numbers, not a whole table. Dates are converted to numbers automatically, and a pure text column comes through as text (useful for chart labels).
Inputs
| Input | Accepts | Required |
|---|---|---|
Table | Table | Yes |
ColumnName | Text | Optional |
Outputs
| Output | Produces |
|---|---|
Series | Series (a list of numbers) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
ColumnName | — | The column to pull out of the table (e.g. Cash_Flow). |
Example
The Projections table has a Cash_Flow column with five annual figures:
-250,000 then 60,000, 75,000, 90,000, 110,000. Point an ExtractColumn at it with
ColumnName set to Cash_Flow, connect the output to an IRR node, and you get
the project's internal rate of return, about 9.8%, without leaving the pipeline.
Tips
- Unlike the other transform nodes, the output is a series of values, not a table, so it does not appear as a tab; it exists to feed calculation and chart nodes.
- Cells that cannot be read as numbers come through as gaps (NaN); an Interpolate node can fill them if needed.