EXAMPLE

...

TransformTransformation:

d-

...

trans

p01Name
RawWrangle	true
Type	step
WrangleText	derive type:single value: YEAR (date)

...

D trans

RawWrangle	true
Type	step
WrangleText	derive type:single value: MONTH (date)
p01Name	Formula type
p01Value	Single row formula
p02Name	Formula
p02Value	MONTH (date)
SearchTerm	New formula

d-

...

trans

p01Name
RawWrangle	true
Type	step
WrangleText	derive type:single value: MONTHNAME (date)

...

D trans

RawWrangle	true
Type	step
WrangleText	derive type:single value: DAY (date)
p01Name	Formula type
p01Value	Single row formula
p02Name	Formula
p02Value	DAY (date)
SearchTerm	New formula

d-

...

trans

p01Name
RawWrangle	true
Type	step
WrangleText	derive type:single value: HOUR (date)

...

D trans

p01Value
RawWrangle	true
Type	step
WrangleText	derive type:single value: MINUTE (date)
p01Name	Formula type

...

D trans

SearchTerm
RawWrangle	true
Type	step
WrangleText	derive type:single value: SECOND (date)
p01Name	Formula type
p01Value	Single row formula
p02Name	Formula
p02Value	SECOND (date)

...

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.

...

Versions Compared