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

...

date
2/8/16 15:41
12/30/15 0:00
4/26/15 7:07

TransformTransformation: 

d-

...

trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: YEAR (date)
p01Name

...

Formula type
p01ValueSingle row formula
p02NameFormula
p02ValueYEAR (date)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: MONTH (date)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueMONTH (date)
SearchTermNew formula

d-

...

trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: MONTHNAME (date)
p01Name

...

Formula type
p01ValueSingle row formula
p02NameFormula
p02ValueMONTHNAME (date)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: DAY (date)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueDAY (date)
SearchTermNew formula

d-

...

trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: HOUR (date)
p01Name

...

Formula type
p01ValueSingle row formula
p02NameFormula
p02ValueHOUR (date)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: MINUTE (date)
p01NameFormula type
p01Value

...

Single row formula
p02NameFormula
p02ValueMINUTE (date)
SearchTermNew formula

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value: SECOND (date)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueSECOND (date)
SearchTerm

...

New formula

Results:

Info

NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned. See the second_date column below.

...