Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

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

...

  • reference to column containing Datetime values used to identify sessions.
  • Numeric value to identify the length of the rolling timeframe that demarcates a session.
  • Unit of measure for the length of the rolling timeframe.

Like other window functionsother windowingorder and group parameters can be applied. You can use the group and order parameters to define the groups of records and the order of those records to which this transform is applied. 

...

In the generated column, identifiers are assigned to each row based on the computed session to which the row data belongs. Session IDs begin at 1 and increment, within each group. 

...

D code

window value:SESSION(Timestamp, 1, hour) order:'Timestamp'

Output: Generates a new column, which contains session identifiers for groups of rows based on 1-hour segments. 

D s
snippetSyntax

D code

window value:SESSION(col_ref, k_integer,unit_of_time) order: order_col [group: group_col]

...

Required?Data TypeExample Value
YesString literal. See below for list.hour

Supported values:  dayhour,   millisecond,   minutesecond

D s
snippetExamples

Example - Assign session identifiers to timestamped events

...