Differences

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

--- transformations:addcolumn [2025/01/09 07:41] – yurii
+++ transformations:addcolumn [2025/01/09 07:54] (current) – [Examples] yurii
@@ Line 35: / Line 35: @@
 =====Examples=====
-**Example #1:** 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
+===Before (source table)===
+Average income and deductions
 ^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^
@@ Line 44: / Line 46: @@
 | Switzerland  |  53716|  48414|  9.87%|
 | Canada  |  45896|  37469|  18.36%|
-\\
-**Action parameters:**
-> New column name: Deductions $
-> Expression: [Gross income] - [Disposable income]
-\\
-**Result table:**
+===After (result table)===
 ^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^Deductions $  ^
 | United States  |  56067|  45582|  18.7%|  10485|
@@ Line 58: / Line 54: @@
 | Canada  |  45896|  37469|  18.36%|  8427|
-\\ \\ \\
+===Action parameters:===
-**Example #2:** Create multiple new columns within the same action.
+> New column name: Deductions $
+> Expression: [Gross income] - [Disposable income]
-\\
-**Action parameters:**
-> New column #1: MyDate = today()
-> New column #2: MyYear = year([MyDate]) //(References the [MyDate] column previously created in this action.)//
 \\