transformations:shiftcolumn
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:shiftcolumn [2018/05/23 22:52] – created dmitry | transformations:shiftcolumn [2021/04/23 01:25] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Shift column | + | {{ transformations: |
+ | ======SHIFT COLUMN UP/DOWN====== | ||
+ | Category: Transform / Advanced \\ | ||
- | This action shifts values in specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom. | + | \\ |
+ | =====Description===== | ||
+ | This action shifts values in the specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom.\\ | ||
- | ===Use cases=== | + | \\ |
- | This action can be used in cases when a comparison with a previous/ | + | =====Use cases===== |
+ | This action can be used in cases when a comparison with a previous/ | ||
- | ===Example=== | + | \\ |
- | Source data: sales by year. | + | =====Action settings===== |
+ | ^Setting^Description^ | ||
+ | |Column|Select the column shift.| | ||
+ | |Shift direction|Select whether the column' | ||
+ | |Shift by N rows< | ||
+ | |Mode|Select whether the results of this action will overwrite the selected column' | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | |||
+ | **Source data:** Sales by year. | ||
^ Year ^ Sales ^ | ^ Year ^ Sales ^ | ||
| 2010 | 10000| | | 2010 | 10000| | ||
Line 15: | Line 32: | ||
| 2014 | 8500| | | 2014 | 8500| | ||
| 2015 | 11300| | | 2015 | 11300| | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Column is " | ||
+ | > Shift " | ||
+ | > Shift by 1 row | ||
+ | > Mode is " | ||
- | Objective: Calculate the delta with previous year. For this, we're appending a new column which is column [Sales] shifted down by 1 row. | ||
- | Result: | + | \\ |
+ | **Result:** | ||
^ Year ^ Sales ^ Prev. year sales ^ | ^ Year ^ Sales ^ Prev. year sales ^ | ||
| 2010 | 10000| | | 2010 | 10000| |
transformations/shiftcolumn.txt · Last modified: 2021/07/19 02:18 by craigt