Differences

This shows you the differences between two versions of the page.

--- transformations:addcolumn [2023/11/24 19:10] – [Remarks] craigt
+++ transformations:addcolumn [2023/11/24 19:18] – craigt
@@ Line 29: / Line 29: @@
 Subsequent expressions can reference columns previously created within the same //Calculate new column(s)// action.  (See example, below)
 \\
 =====Examples=====
-**Example:** Calculate the $ amount of compulsory deductions for each country
+**Example #1:** Calculate the $ amount of compulsory deductions for each country
 **Source table:** Average income and deductions
@@ Line 54: / Line 55: @@
 | Switzerland  |  53716|  48414|  9.87%|  5302|
 | Canada  |  45896|  37469|  18.36%|  8427|
+\\ \\ \\
+**Example #2:** Create multiple new columns within the same action.
+\\
+**Action parameters:**
+> New column #1: MyDate = today()
+> New column #2: MyYear = year([MyDate]) //(References the [MyDate] column previously created in this action.)//
 \\