Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

D trans
RawWrangletrue
p03ValueB
Typestep
WrangleTextmove col:C after:B
p01NameColumn(s)
p01ValueC
p02NameOption
p02ValueAfter
p03NameColumn
SearchTermMove columns

Results:

ABC
147
258
369

Example - Move multiple columns

The following examples illustrate how you can move multiple columns in a single transformation.

Source:

ABCDEF
123456
789101112
131415161718
192021222324

Transformation:

D trans
RawWrangletrue
p03ValueE
Typestep
WrangleTextmove col: A,B,C position: after after: E
p01NameColumn(s)
p01ValueA,B,C
p02NameOption
p02ValueAfter
p03NameColumn
SearchTermMove columns

D trans
RawWrangletrue
p03ValueE
Typestep
WrangleTextmove col: B,F position: before before: E
p01NameColumn(s)
p01ValueB,F
p02NameOption
p02ValueBefore
p03NameColumn
SearchTermMove columns

Results:

DBFEAC
426513
108121179
161418171315
222024231921

D s also
labelwrangle_transform_move