Documentation Index
Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
Use this file to discover all available pages before exploring further.
When you migrate an Alteryx workflow to a Prophecy pipeline, the transpiler reads uploaded files and maps the Alteryx tools to Prophecy gems to create
ß
- a visual pipeline
- open-source code.
- a visual pipeline
- open-source code.
The following tables list the Alteryx components that Prophecy supports, along with the corresponding Prophecy gems mapped after transpilation.
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. | 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 |
| 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. |
