User Tools

Site Tools


transformations:addcolumn

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
transformations:addcolumn [2021/04/09 09:21] – [See also] dmitrytransformations:addcolumn [2021/07/19 00:42] craigt
Line 40: Line 40:
 | Switzerland  |  53716|  48414|  9.87%| | Switzerland  |  53716|  48414|  9.87%|
 | Canada  |  45896|  37469|  18.36%| | Canada  |  45896|  37469|  18.36%|
 +\\ 
 **Action parameters:** **Action parameters:**
 > New column name: Deductions $ > New column name: Deductions $
 > Expression: [Gross income] - [Disposable income] > Expression: [Gross income] - [Disposable income]
  
- +\\  
-**Output table:**+**Result table:**
  
 ^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^Deductions $  ^ ^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^Deductions $  ^
Line 54: Line 54:
 | Canada  |  45896|  37469|  18.36%|  8427| | Canada  |  45896|  37469|  18.36%|  8427|
  
 +\\  
 +====Community examples==== 
 +  * [[https://community.easymorph.com/t//1273/6|Split Excel spreadsheets into multiple spreadsheets]] ([[https://community.easymorph.com/uploads/short-url/6iWYdZJc4yAvqYMbTGZWXtVFmvL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Spreadsheet A.xlsx//;\\ Action position: //3//) 
 +  * [[https://community.easymorph.com/t//1283/2|How to split Number and Alphabetical Characters from a Cell]] ([[https://community.easymorph.com/uploads/short-url/wzaamfKXHrZWs690Lc5akE2OWsV.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//) 
 +  * [[https://community.easymorph.com/t//1489/1|How to calculate YoY change using self-join]] ([[https://community.easymorph.com/uploads/short-url/n3koKAS8IXLsc5Oa9647ELLijkp.morph|Project]]; Module: //Main//; Group: //Self-join//; Table: //This year//; Action position: //4//) 
 +  * [[https://community.easymorph.com/t//1587/7|How to format the duration in more than 24h]] ([[https://community.easymorph.com/uploads/short-url/w6CnxwiidYjcJHNRrmUIXI74NC2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //6//) 
 +  * [[https://community.easymorph.com/t//1919/2|Split after last space]] ([[https://community.easymorph.com/uploads/short-url/obnKd1zEnmJ9NkAEx53ho7sz9Gw.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//) 
 +  * [[https://community.easymorph.com/t//2060/2|Search, remove, and shift]] ([[https://community.easymorph.com/uploads/short-url/cCqOTak9SLKPXbityR5IAlgULJa.morph|Project]]; Module: //Main//; Group: //Regrouping//; Table: //ExtractingData.xlsx//; Action position: //5//) 
 +  * [[https://community.easymorph.com/t//2488/2|Split text into columns problem - split when data changes from text to numbers]] ([[https://community.easymorph.com/uploads/short-url/fKwR2v9mZiSQ6cXclMb446ittht.morph|Project]]; Module: //Main//; Group: //Group 1//;\\ Table: //Variant 1//; Action position: //2//)
  
 \\  \\ 
Line 62: Line 70:
   *Click the drop-down arrow in a column heading and select "Insert column(s)".   *Click the drop-down arrow in a column heading and select "Insert column(s)".
 In either case, a new column with a default column name will appear //after// the selected column. In either case, a new column with a default column name will appear //after// the selected column.
- 
- 
  
 \\  \\ 
transformations/addcolumn.txt · Last modified: 2024/02/05 14:20 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki