Automated migration results
When Import detects an Alteryx Count Records tool, it generates a Reformat gem that computes a row count using an expression such ascount(1).
This expression counts all input rows and preserves the semantics of the Alteryx Count Records tool.
Manually replicate in Prophecy
To reproduce Count Records behavior manually:- Add a CountRecords gem to the canvas.
- Connect the gem to the dataset whose rows should be counted.
- Select Count total number of records.
Configuration options
Alteryx (Count Records tool)
The Count Records tool requires no configuration. It always returns a global count of input rows.Prophecy (CountRecords gem)
Select Count total number of records, which computes a global row count for the connected dataset.Output behavior
Both Alteryx’s Count Records tool and Prophecy’s CountRecords gem produce:- A single output row
- A single column containing the total number of input records
Known caveats
Import may represent Count Records logic using a Reformat gem with an expression likecount(1) rather than the CountRecords gem itself. Using a constant expression ensures that the count does not depend on any input column and mirrors Alteryx’s row-count semantics.
Example
Goal: return a count of rows for the input dataset below.Input dataset
| record_id | event_date | amount |
|---|---|---|
| 1 | 2025-01-01 | 10 |
| 1 | 2025-01-05 | 5 |
| 1 | 2025-01-10 | 7 |
| 2 | 2025-01-03 | 4 |
| 2 | 2025-01-07 | 6 |
Alteryx Count Records tool
The tool counts all incoming rows.Resulting output
| count |
|---|
| 5 |
Prophecy equivalent (CountRecords gem)
The CountRecords gem produces the same single-row output with a total count of5.