Alteryx Running Total tool > Prophecy WindowFunction Gem

​

Automated migration results

• The selected value field is mapped to a sum aggregation function.
• Grouping fields map to the gem’s Partition by configuration.
• Row ordering maps to the gem’s Order by configuration.

​

Manually replicate in Prophecy

1. Add a WindowFunction gem to the canvas.
2. Configure Order by column(s) to define the row sequence.
3. Configure Partition by column(s) if the running total should reset by group.
4. Configure a target column and use a sum expression for the running total.

​

Configuration options

​

In Alteryx (Running Total tool)

• Field(s) for Group By (optional).
• Field for Create Running Total.

​

In Prophecy (WindowFunction gem)

• Partition by columns: the grouping keys that reset the running total (mirrors the Running Total tool’s “Group by”).
• Order by columns: the columns that define row sequence.
• Window use: create the running total target column using a sum window expression over the running-total field.

​

Output behavior

• Alteryx outputs a new column containing the cumulative value for each row.
• Prophecy outputs a derived column whose value reflects the cumulative aggregation over the defined window.

​

Known caveat

​

Example

​

Input dataset

​

Alteryx Running Total tool

• Field for group by: record_id
• Field for running total: amount

​

Prophecy equivalent (WindowFunction gem)

• Partition by: record_id
• Order by: event_date
• Window use: add Target column RunTot_amount. Configure Expression as function > sum with column amount as parameter.

​

Resulting output