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

...

Data
Happy
Dog
Happy Happy Dog

TransformTransformation:

D code

valuestocols col:Data value:'X'

...

DateNameonboardingChecklist
4/4/16Bowie KuhnOrientation
4/4/16Happy ChandlerContact Info
4/4/16Bowie KuhnContact Info
4/4/16Bowie KuhnAcquire Computer
4/4/16Bud SeligProduct Training
4/4/16Bud SeligOrientation
4/5/16Happy ChandlerHR Policies Training
4/5/16Happy ChandlerOrientation
4/5/16Happy ChandlerAcquire Computer
4/5/16Bowie KuhnHR Policies Training
4/5/16Bud SeligHR Policies Training
4/5/16Bud SeligContact Info
4/6/16Happy ChandlerProduct Training

TransformTransformation:

The following transform creates columns for each of the values in the onboardingChecklist column and adds a yes value where there is a match for the row:

d-

...

trans
RawWrangletrue
Typestep
WrangleTextvaluestocols col: onboardingChecklist value:'yes'
p01NameColumn
p01ValueonboardingChecklist
p02NameFill when present
p02Value'yes'
SearchTermConvert values to columns

Results:

In the generated columns, you can quickly assess whether all three employees have completed an individual onboarding item:

...