...
Results:
Example - Move multiple columns
The following examples illustrate how you can move multiple columns in a single transformation.
Source:
| A | B | C | D | E | F |
|---|
| 1 | 2 | 3 | 4 | 5 | 6 |
| 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 |
Transformation:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | E |
|---|
| Type | step |
|---|
| WrangleText | move col: A,B,C position: after after: E |
|---|
| p01Name | Column(s) |
|---|
| p01Value | A,B,C |
|---|
| p02Name | Option |
|---|
| p02Value | After |
|---|
| p03Name | Column |
|---|
| SearchTerm | Move columns |
|---|
|
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | E |
|---|
| Type | step |
|---|
| WrangleText | move col: B,F position: before before: E |
|---|
| p01Name | Column(s) |
|---|
| p01Value | B,F |
|---|
| p02Name | Option |
|---|
| p02Value | Before |
|---|
| p03Name | Column |
|---|
| SearchTerm | Move columns |
|---|
|
Results:
| D | B | F | E | A | C |
|---|
| 4 | 2 | 6 | 5 | 1 | 3 |
| 10 | 8 | 12 | 11 | 7 | 9 |
| 16 | 14 | 18 | 17 | 13 | 15 |
| 22 | 20 | 24 | 23 | 19 | 21 |
| D s also |
|---|
| label | wrangle_transform_move |
|---|
|
