- a visual pipeline
- open-source code.
- a visual pipeline
- open-source code.
If you don’t see a particular component on this list, you can include custom abilities beyond custom scripting. To learn more, see gem Builder for SQL.
Input and output
The following table lists mappings for Alteryx In/Out tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Browse | Data Explorer | Lets you explore and analyze data samples directly within the UI. For a full side-by-side comparison, see Alteryx Browse Tool > Prophecy Data Explorer. |
| Date Time Now | Reformat gem | Returns the current timestamp or date at the start of pipeline execution. For a full side-by-side comparison, see alteryx-in-out-tools/alteryx DateTime Now Tool > Prophecy Reformat Gem. |
| Directory | Directory gem | Lists file paths and metadata for dynamic ingestion. For a full side-by-side comparison, see Alteryx Directory Tool > Prophecy Directory gem. |
| Input Data | Source gem | Facilitates data ingestion from supported sources, including schema inference and preview. For a full side-by-side comparison, see Alteryx Input Data Tool > Prophecy Source Gem. |
| Output Data | Target gem | Allows you to save transformed data to various destinations, databases, or file formats. For a full side-by-side comparison, see Alteryx Output Data Tool > Prophecy Target Gem. |
| Text Input | Table gem: Seed | Provides a seed source option for manually inputting data to create small datasets. For a full side-by-side comparison, see Alteryx Text Input Tool > Prophecy Table Gem (Seed). |
Preparation
The following table lists the mapping for Alteryx Preparation tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Data Cleansing | DataCleansing gem | Standardizes data formats and addresses missing or null values in the data. For a full side-by-side comparison, see Alteryx Data Cleansing Tool > Prophecy DataCleansing Gem. |
| Filter | Filter gem | Filters data based on the provided filter condition. For a full side-by-side comparison, see Alteryx Filter Tool > Prophecy Filter Gem. |
| Formula | Reformat gem | Transforms one or more column names or values by using expressions and functions. For a full side-by-side comparison, see Alteryx Formula Tool > Prophecy Reformat Gem. |
| Imputation | Reformat gem + Join gem | Replaces specific values with a user-specified value, such as an aggregate of the column using the Reformat and Join gems. Often used for null values. For a full side-by-side comparison, see Alteryx Imputation tool > Prophecy Reformat + Join gems. |
| Multi-Field Binning | Reformat gem + Join gem | Tiles or bins multiple fields by assigning tile or bin numbers. For a full side-by-side comparison, see Alteryx Multi-Field Binning tool > Prophecy Reformat + Join gems. |
| Multi-Field Formula | MultiColumnRename gem | Renames, updates, or changes the type of a set of columns. For a full side-by-side comparison, see Alteryx Multi-Field Formula tool > Prophecy Multi-Column Edit Gem. |
| Multi-Row Formula | Reformat gem | In Alteryx, perform calculations using values from adjacent rows. Currently, Prophecy does not support true row-relative logic. Use SQL window functions (LAG, LEAD, SUM OVER) in a Reformat gem for simple lookback or running-total cases. Flag complex iterative logic for manual review during migration. For a full side-by-side comparison, see Alteryx Multi-Row Formula tool > Prophecy Window Functions gem. |
| Oversample Field | Reformat gem + Filter | Addresses class imbalance in predictive modeling—when one category (such as “Default = Yes”) appears far less often than another. Use a Reformat Gem to assign random values and compute class counts, followed by a Filter gem to keep all minority-class rows and a matching number of randomly selected majority-class rows for a balanced dataset. For a full side-by-side comparison, see Alteryx Oversample Field tool > Prophecy Reformat + Filter gems. |
| Record ID | RecordID gem | Generates IDs for each record incrementally or randomly. |
| Select Records | Reformat gem + Filter | Generates record IDs and chooses a subset of records based on the record ID. |
| Select | Reformat gem | Includes, excludes, reorders, casts, or renames columns. |
| Sort | OrderBy gem | Sorts incoming records based on one or more selected fields. |
| Tile | WindowFunction gem | Assigns tile values to each record with the ntile() function. |
| Unique | FindDuplicates gem | Filters rows in a dataset based on how frequently they appear. |
Join
The following table lists the mapping for Alteryx Join tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Append Fields | Join gem | When the condition is true, performs Inner/Outer Join. |
| Find Replace | Reformat gem | Finds a string and updates the value in a column. |
| Join | Join gem | Joins two data sources based on a common field. |
| Join Multiple | Join gem | Joins multiple data sources on a common field. |
| Union | Union gem | Combines records from multiple data sources into one output. |
Parse
The following table lists the mapping for Alteryx Parse tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| DateTime | Reformat gem | Uses data functions such as current_date() to manipulate date and time fields. |
| RegEx | Regex gem | Enables pattern matching and text extraction using regular expressions. |
| XML Parse | XMLParse gem | Parses JSON or XML input fields with schema inference or predefined schema. |
Transform
The following table lists the mapping for Alteryx Transform tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Arrange | Reformat gem | Rearranges columns in the dataset. |
| Count Records | CountRecords gem | Counts the number of records in the dataset. |
| Cross Tab | SQL Statement gem | Pivots data on unique values of a specified column. |
| Make Columns | Reformat gem + WindowFunction | Wraps and rearranges rows of data into columns. |
| Running Total | WindowFunction gem | Calculates a cumulative sum on a numeric field using unbounded precedence. |
| Summarize | Aggregate gem | Performs functions and calculations on data that don’t contain domain-specific actions. |
| Transpose | SQL Statement gem | Uses pivoting logic to change data orientation. |
| Weighted Average | Aggregate gem | Computes a weighted average using required expressions. |
Developer
The following table lists the mapping for Alteryx Developer tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Base64 Encoder | DataEncoderDecoder gem | Encodes a string field using the base64 method. |
| Download | RestAPI gem | Enriches a DataFrame by adding columns from REST API output. |
| Dynamic Rename | MultiColumnRename gem | Renames multiple columns systematically. |
| Dynamic Select | DynamicSelect gem | Dynamically filters columns based on your conditions. |
| JSON Parse | JSONParse gem | Parses and converts JSON or XML into a tabular format. |
| Dynamic Input | DynamicInput gem | Run SQL queries that update automatically based on your incoming data. |
Documentation
The following table lists the mapping for Alteryx Documentation tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Tool Container | Visual Containers | Divide your pipeline into different sections by visually organizing related gems. |
Laboratory
The following table lists the mapping for Alteryx Laboratory tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Transpose In-DB | SQL Statement gem | Uses pivoting logic to transform data orientation within the database. |
In-Database
The following table lists the mapping for Alteryx In-Database tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Browse In-DB | Data Explorer | Lets you explore and analyze data samples directly within the UI. |
| Connect In-DB | Prophecy Fabric | Prophecy runs natively on execution engines such as Databricks and Snowflake. |
| Data Stream In | Source gem | Facilitates data ingestion from supported sources, including schema inference and preview. |
| Data Stream Out | Target gem | Allows you to save transformed data to various destinations, databases, or file formats. |
| Filter In-DB | Filter gem | Filters models based on the provided filter condition. |
| Formula In-DB | Reformat gem | Transforms one or more column names or values by using expressions and functions. |
| Join In-DB | Join gem | Joins multiple data sources on a common field. |
| Select In-DB | Reformat gem | Uses the Reformat gem to select, deselect, rename, and reorder columns. |
| Summarize In-DB | Aggregate gem | Performs functions and calculations on data that don’t contain domain-specific actions. |
| Union In-DB | Union gem | Combines records from multiple data sources into one output. |
| Write Data In-DB | Table gem | Natively writes to your default warehouse connection in a Prophecy fabric. |