Expression Aliases for Dataframe Processing Method

From QPR ProcessAnalyzer Wiki
Jump to: navigation, search

This pages lists all expression aliases that can be used in the DataFrame based root expression (i.e. ProcessingMethod is dataframe and ContextType is model).

The following expression aliases are supported in the beginning of root expression:

  • Cases: Alias for an expression returning SqlDataFrame for cases. There is the following columns:
    • CaseId
    • Rest of the fields are case attributes.
  • Events: Alias for an expression returning an SqlDataFrame for events with following columns:
    • CaseId
    • EventType
    • Timestamp
    • Rest of the fields are event attributes.
  • EventTypes: Alias for an expression returning SqlDataFrame for event types. There is the following column:
    • EventType: Event type name.
  • Variations: Alias for an expression returning SqlDataFrame for variations. There the following column:
    • Variation: name of the variation concatenated event type names separated by separator "#,#".
  • Flows: Alias for an expression returning SqlDataFrame for flows of the model. There are the following columns:
    • FromEventType: Event type name of the flow start.
    • ToEventType: Event type name of the flow end.
  • FlowOccurrences: Alias for an expression returning SqlDataFrame for flow occurrences of the model. There are the following columns:
    • CaseId: Case id.
    • FromEventType: Event type name of the flow start.
    • FromTimeStamp: Time stamp of the flow start event.
    • From<event attribute name>: Event attribute value of the flow start event. (<event attribute name> is replaced by the actual attribute name.)
    • ToEventType: Event type name of the flow end.
    • ToTimeStamp: Time stamp of the flow end event.
    • To<event attribute name>: Event attribute value of the flow end event. (<event attribute name> is replaced by the actual attribute name.)

After the alias, any functions supported by the SqlDataFrame can be used.

The alias used specifies the root aggregation level. If an expression alias was not matched, the root aggregation level of the analysis is considered to be "Custom".