Offset Column
About Offset Column
Offset Column takes the contents of a selected column and repeats it in a new column, offsetting the values by one row up or down.
Example
Offset Column is useful for deriving the upper or lower bounds of a range, where only one of those values has been supplied. In this example, only the lower bound of the range has been provided in the ‘From’ column.
Input data |
|
|---|---|
ID |
From |
1 |
0 |
2 |
50 |
3 |
100 |
4 |
250 |
5 |
1000 |
To produce an upper bound in a ‘To’ column, the ‘From’ column is offset up one row and the blank value at the bottom is populated with the value 100,000. The first value in the ‘From’ column will be clipped off when data is offset into the ‘To’ column.
Output data |
||
|---|---|---|
ID |
From |
To |
1 |
0 |
50 |
2 |
50 |
100 |
3 |
100 |
250 |
4 |
250 |
1000 |
5 |
1000 |
100000 |
Using Offset Column
To use Offset Column:
- Select ‘Offset Column’ from the Operations menu.
- Define an input column, output column, offset direction, and optionally a value to replace the blank created at the start or end of the column.
Input column
Select the column that the new column will be derived from.
Output column name
The new column containing the offset rows. Selecting an existing column name will overwrite that column.
Offset direction
The rows in the output column will be offset by one row. Select whether to offset them up or down.
Fill blank value
Optional. If a value is entered here, it will populate the blank value created at the start or end of the new column.