Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
transformations:addcolumn [2021/04/09 09:21] – [See also] dmitry | transformations:addcolumn [2021/07/19 00:42] – craigt |
---|
| 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 $ ^ |
| 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//) |
| |
\\ | \\ |
*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. |
| |
| |
| |
\\ | \\ |