- 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. For a full side-by-side comparison, see Alteryx Append Fields Tool > Prophecy Join Gem. |
| Find Replace | Join gem + Reformat gem | Finds a string and updates the value in a column. For a full side-by-side comparison, see Alteryx Find Replace tool > Prophecy Join gem + Reformat gem. |
| Join | Join gem | Joins two data sources based on a common field. For a full side-by-side comparison, see Alteryx Join Tool > Prophecy Join Gem. |
| Join Multiple | Join gem | Joins multiple data sources on a common field. For a full side-by-side comparison, see Alteryx Join Multiple Tool > Prophecy Join Gem. |
| Union | Union gem | Combines records from multiple data sources into one output. For a full side-by-side comparison, see Alteryx Union Tool > Prophecy Union Gem. |
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. For a full side-by-side comparison, see Alteryx DateTime tool > Prophecy Reformat gem. |
| RegEx | Regex gem | Enables pattern matching and text extraction using regular expressions. For a full side-by-side comparison, see Alteryx RegEx Tool > Prophecy Regex Gem. |
| XML Parse | XMLParse gem | Parses JSON or XML input fields with schema inference or predefined schema. For a full side-by-side comparison, see Alteryx XML Parse Tool > Prophecy XMLParse gem |
Transform
The following table lists the mapping for Alteryx Transform tools.| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Arrange | Reformat gem | Rearranges columns in the dataset. For a full side-by-side comparison, see Alteryx Arrange Tool > Prophecy Reformat Gem. |
| Count Records | CountRecords gem | Counts the number of records in the dataset. For a full side-by-side comparison, see Alteryx Count Records Tool > Prophecy CountRecords Gem. |
| Cross Tab | Pivot gem | Pivots data on unique values of a specified column. For a full side-by-side comparison, see Alteryx Cross Tab Tool > Prophecy Pivot Gem. |
| Make Columns | Reformat gem + WindowFunction gem + Script gem | Wraps and rearranges rows of data into columns. For a full side-by-side comparison, see Alteryx Make Columns tool > Prophecy WindowFunction + Reformat + Script Gems. |
| Running Total | WindowFunction gem | Calculates a cumulative sum on a numeric field using unbounded precedence. For a full side-by-side comparison, see Alteryx Running Total tool > Prophecy WindowFunction Gem. |
| Summarize | Aggregate gem or Deduplicate gem or Reformat gem | Performs functions and calculations on data that don’t contain domain-specific actions. For a full side-by-side comparison, see Alteryx Summarize Tool > Prophecy Aggregate, Reformat, or Deduplicate Gems. |
| Transpose | SQL Statement gem | Uses pivoting logic to change data orientation. For a full side-by-side comparison, see Alteryx Transpose Tool > Prophecy Unpivot Gem. |
| Weighted Average | Aggregate gem or Reformat gem | Computes a weighted average using required expressions. For a full side-by-side comparison, see Alteryx Weighted Average tool > Prophecy Reformat and Aggregate Gems. |
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 mappings for Alteryx In-Database tools. For the most part, Import processes Alteryx In-Database tools in the same way it processes their standard equivalents. For example, when you import a workflow that uses a Filter In-DB tool, Import converts it to a standard Filter gem; Import preserves filtering logic, but execution does not occur in the original database.Prophecy workflows always execute in the configured fabric; unlike Alteryx, there is no separate “In-DB” toolset or execution mode.
| Alteryx Tool | Prophecy | Description |
|---|---|---|
| Browse In-DB | Data Explorer | Lets you explore and analyze data samples directly within the UI. Import handles Browse In-DB in the same way it handles Alteryx’s Browse tool; Import deletes instances of the Browse In-DB tool because Prophecy provides the same functionality with the Data Explorer. For a discussion of how the Browse tool compares to the Data Explorer, see Alteryx Browse Tool > Prophecy Data Explorer. |
| Connect In-DB | Source gem | Import converts instances of Connect In-DB tools to Source gems, similar to how Import handles Alteryx’s Input Data tools. For a discussion of how the Input Data tool compares to the Source gem, see Alteryx Input Data Tool > Prophecy Source Gem. |
| Data Stream In | Source gem | Import converts Data Stream In tools to Source gems, similar to how Import handles Alteryx’s Input Data tools. For a discussion of how the Input Data tool compares to the Source gem, see Alteryx Input Data Tool > Prophecy Source Gem. |
| Data Stream Out | Target gem | Import converts instances of Data Stream Out tools to Target gems, similar to how Import handles Alteryx’s Output Data tools. For a discussion of how the Output Data tool compares to the Source gem, see Alteryx Input Data Tool > Prophecy Source Gem. |
| Filter In-DB | Filter gem | Filters models based on the provided filter condition. Import handles Filter in-DB the same way it handles Alteryx’s Filter tool, converting the Filter in-DB tool to a Filter gem. For a discussion of how the Filter tool compares to the Filter gem, see Alteryx Filter Tool > Prophecy Filter Gem. |
| Formula In-DB | Reformat gem | Transforms one or more column names or values by using expressions and functions. Import handles Formula in-DB the same way it handles Alteryx’s Formula tool, converting the Formula In-DB tool to a Reformat gem. |
| Join In-DB | Join gem | Joins multiple data sources on a common field. Import handles Join in-DB the same way it handles Alteryx’s Join tool, converting the Join In-DB tool to a Reformat gem. For a discussion of how the Join tool compares to the Join gem, see Alteryx Join Tool > Prophecy Join Gem. |
| 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. Import handles Join in-DB the same way it handles Alteryx’s Summarize tool, converting the Summarize In-DB tool to an Aggregate, Deduplicate, or Reformat gem, depending on the Summarize In-DB tool’s configuration in Alteryx. |
| Union In-DB | Union gem | Combines records from multiple data sources into one output. Import handles Union in-DB the same way it handles Alteryx’s Union tool, converting the Union In-DB tool to a Union gem. For a discussion of how the Union tool compares to the Union gem, see Alteryx Union Tool > Prophecy Union Gem. |
| Write Data In-DB | Table gem | Writes to your default warehouse connection in a Prophecy fabric. |