Triggered Unfold

Description

This activity reassembles several rows into a structured format when triggered by a user-specified value.

Input

Data

Output

Transformed Data

Configuration Fields

• Key column The column identifying the unique key.
• Fold column The column containing the trigger value to process.
• Trigger value The specific value in the Fold column that indicates the start of a new session.
• Data column The column holding the data to associate with each event.

Sample Input

SessionID	EventType	EventData
1	START	A
1	DATA	B
1	DATA	C
2	START	X
2	DATA	Y

Sample Configuration

Sample Output

SessionID	START	DATA
1	A	C
2	X	Y