transformations:addcolumn
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:addcolumn [2021/07/19 00:42] – craigt | transformations:addcolumn [2023/11/24 19:16] – [Examples] craigt | ||
---|---|---|---|
Line 24: | Line 24: | ||
\\ | \\ | ||
=====Remarks===== | =====Remarks===== | ||
- | The expression is calculated for every row. Other column values in the same row can be referred to by column names in square brackets. It's not possible to refer from one row to another row or to another table. | + | The expression is calculated for every row. Other column values in the same row can be referred to by column names in square brackets. It's not possible to refer to other rows or tables. |
Instead of an expression, this action can insert a full column of static text or numeric values.\\ | Instead of an expression, this action can insert a full column of static text or numeric values.\\ | ||
+ | Subsequent expressions can reference columns previously created within the same //Calculate new column(s)// action. | ||
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
Line 53: | Line 54: | ||
| Switzerland | | Switzerland | ||
| Canada | | Canada | ||
+ | |||
+ | \\ \\ \\ | ||
+ | **Example: | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > New column #1: MyDate = today() | ||
+ | > New column #2: MyYear = year([MyDate]) // | ||
+ | |||
+ | |||
\\ | \\ |
transformations/addcolumn.txt · Last modified: 2024/02/05 14:20 by craigt