Differences

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

--- transformations:addcolumn [2023/11/24 19:16] – [Examples] craigt
+++ transformations:addcolumn [2024/02/05 14:20] (current) – craigt
@@ Line 21: / Line 21: @@
 |Expression or Value|Options:  //It's an expression// or //It's a text or number//.  Enter the expression used to calculate the new column values,\\ or, enter the text or numeric value that will be repeated for all values.|
 |Position|Choose where the new column(s) will appear in the dataset.  Options:  //Rightmost//, //Leftmost//, or //After column//\\ (and select the column the new column(s) will appear after).|
+|If column already exists|Choose how EasyMorph reacts if the new column name already exists in the dataset.\\  Options: //Rename new column// (a sequential number is appended to the column name), //Do not create new column//\\ (the column is not created and the workflow continues), or //Fail// (the action displays an error and the workflow stops).|
 \\
@@ Line 29: / Line 30: @@
 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 56: / Line 59: @@
 \\ \\ \\
-**Example:** Create multiple new columns within the same action.
+**Example #2:** Create multiple new columns within the same action.
 \\