> ## 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.
# Alteryx to SQL tool mapping
> List of supported Alteryx components and how they map to Prophecy SQL gems
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
ß
1. a visual pipeline
2. open-source code.
3. a visual pipeline
4. 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](/data-analysis/development/extensibility/sql-gem-builder).
## Input and output
The following table lists mappings for Alteryx [In/Out tools](https://help.alteryx.com/current/en/designer/tools/in-out-tools.html).
| Alteryx Tool | Prophecy | Description |
| -------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [Browse](https://help.alteryx.com/current/en/designer/tools/in-out-tools/browse-tool.html) | [Data Explorer](/data-analysis/development/runs/data-explorer/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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-browse-tool). |
| [Date Time Now](https://help.alteryx.com/current/en/designer/tools/in-out-tools/date-time-now-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-datetime-now). |
| [Directory](https://help.alteryx.com/current/en/designer/tools/in-out-tools/directory-tool.html) | [Directory gem](/data-analysis/gems/custom/directory) | Lists file paths and metadata for dynamic ingestion. For a full side-by-side comparison, see [Alteryx Directory Tool > Prophecy Directory gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-directory-tool). |
| [Input Data](https://help.alteryx.com/current/en/designer/tools/in-out-tools/input-data-tool.html) | [Source gem](/data-analysis/gems/source-target/source-target) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-input-data-tool). |
| [Output Data](https://help.alteryx.com/current/en/designer/tools/in-out-tools/output-data-tool.html) | [Target gem](/data-analysis/gems/source-target/source-target) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-output-data-tool). |
| [Text Input](https://help.alteryx.com/current/en/designer/tools/in-out-tools/text-input-tool.html) | [Table gem: Seed](/data-analysis/gems/source-target/table/prophecy-warehouse#seeds) | 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)](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-text-input-tool). |
## Preparation
The following table lists the mapping for Alteryx [Preparation tools](https://help.alteryx.com/current/en/designer/tools/preparation.html).
| Alteryx Tool | Prophecy | Description |
| ------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Data Cleansing](https://help.alteryx.com/current/en/designer/tools/preparation/data-cleansing-tool.html) | [DataCleansing gem](/data-analysis/gems/prepare/data-cleansing) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-data-cleansing-tool). |
| [Filter](https://help.alteryx.com/current/en/designer/tools/preparation/filter-tool.html) | [Filter gem](/data-analysis/gems/prepare/filter) | Filters data based on the provided filter condition. For a full side-by-side comparison, see [Alteryx Filter Tool > Prophecy Filter Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-filter-tool). |
| [Formula](https://help.alteryx.com/current/en/designer/tools/preparation/formula-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-formula-tool). |
| [Imputation](https://help.alteryx.com/current/en/designer/tools/preparation/imputation-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) + [Join gem](/data-analysis/gems/join-split/join) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-imputation-tool). |
| [Multi-Field Binning](https://help.alteryx.com/current/en/designer/tools/preparation/multi-field-binning-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) + [Join gem](/data-analysis/gems/join-split/join) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-multi-field-binning-tool). |
| [Multi-Field Formula](https://help.alteryx.com/current/en/designer/tools/preparation/multi-field-formula-tool.html) | [MultiColumnRename gem](/data-analysis/gems/prepare/multi-column-rename) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-multi-field-formula-tool). |
| [Multi-Row Formula](https://help.alteryx.com/current/en/designer/tools/preparation/multi-row-formula-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-multi-row-formula-tool). |
| [Oversample Field](https://help.alteryx.com/current/en/designer/tools/preparation/oversample-field-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) + [Filter](/data-analysis/gems/prepare/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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-oversample-field-tool). |
| [Record ID](https://help.alteryx.com/current/en/designer/tools/preparation/record-id-tool.html) | [RecordID gem](/data-analysis/gems/prepare/record-id) | Generates IDs for each record incrementally or randomly. |
| [Select Records](https://help.alteryx.com/current/en/designer/tools/preparation/select-records-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) + [Filter](/data-analysis/gems/prepare/filter) | Generates record IDs and chooses a subset of records based on the record ID. |
| [Select](https://help.alteryx.com/current/en/designer/tools/preparation/select-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | Includes, excludes, reorders, casts, or renames columns. |
| [Sort](https://help.alteryx.com/current/en/designer/tools/preparation/sort-tool.html) | [OrderBy gem](/data-analysis/gems/prepare/order-by) | Sorts incoming records based on one or more selected fields. |
| [Tile](https://help.alteryx.com/current/en/designer/tools/preparation/tile-tool.html) | [WindowFunction gem](/data-analysis/gems/transform/window) | Assigns tile values to each record with the `ntile()` function. |
| [Unique](https://help.alteryx.com/current/en/designer/tools/preparation/unique-tool.html) | [FindDuplicates gem](/data-analysis/gems/prepare/find-duplicates) | Filters rows in a dataset based on how frequently they appear. |
## Join
The following table lists the mapping for Alteryx [Join tools](https://help.alteryx.com/current/en/designer/tools/join.html).
| Alteryx Tool | Prophecy | Description |
| ------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [Append Fields](https://help.alteryx.com/current/en/designer/tools/join/append-fields-tool.html) | [Join gem](/data-analysis/gems/join-split/join) | When the condition is true, performs Inner/Outer Join. For a full side-by-side comparison, see [Alteryx Append Fields Tool > Prophecy Join Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-append-fields). |
| [Find Replace](https://help.alteryx.com/current/en/designer/tools/join/find-replace-tool.html) | [Join gem](/data-analysis/gems/join-split/join) + [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-find-replace). |
| [Join](https://help.alteryx.com/current/en/designer/tools/join/join-tool.html) | [Join gem](/data-analysis/gems/join-split/join) | Joins two data sources based on a common field. For a full side-by-side comparison, see [Alteryx Join Tool > Prophecy Join Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-join). |
| [Join Multiple](https://help.alteryx.com/current/en/designer/tools/join/join-multiple-tool.html) | [Join gem](/data-analysis/gems/join-split/join) | Joins multiple data sources on a common field. For a full side-by-side comparison, see [Alteryx Join Multiple Tool > Prophecy Join Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-join-multiple). |
| [Union](https://help.alteryx.com/current/en/designer/tools/join/union-tool.html) | [Union gem](/data-analysis/gems/join-split/union) | Combines records from multiple data sources into one output. For a full side-by-side comparison, see [Alteryx Union Tool > Prophecy Union Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-union). |
## Parse
The following table lists the mapping for Alteryx [Parse tools](https://help.alteryx.com/current/en/designer/tools/parse.html).
| Alteryx Tool | Prophecy | Description |
| ----------------------------------------------------------------------------------------- | ---------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [DateTime](https://help.alteryx.com/current/en/designer/tools/parse/datetime-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-parse-tools/alteryx-datetime). |
| [RegEx](https://help.alteryx.com/current/en/designer/tools/parse/regex-tool.html) | [Regex gem](/data-analysis/gems/parse/regex) | Enables pattern matching and text extraction using regular expressions. For a full side-by-side comparison, see [Alteryx RegEx Tool > Prophecy Regex Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-parse-tools/alteryx-regex). |
| [XML Parse](https://help.alteryx.com/current/en/designer/tools/parse/xml-parse-tool.html) | [XMLParse gem](/data-analysis/gems/parse/xml-parse) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-parse-tools/alteryx-xml-parse) |
## Transform
The following table lists the mapping for Alteryx [Transform tools](https://help.alteryx.com/current/en/designer/tools/transform.html).
| Alteryx Tool | Prophecy | Description |
| ----------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [Arrange](https://help.alteryx.com/current/en/designer/tools/transform/arrange-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | Rearranges columns in the dataset. For a full side-by-side comparison, see [Alteryx Arrange Tool > Prophecy Reformat Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-arrange). |
| [Count Records](https://help.alteryx.com/current/en/designer/tools/transform/count-records-tool.html) | [CountRecords gem](/data-analysis/gems/transform/count-records) | Counts the number of records in the dataset. For a full side-by-side comparison, see [Alteryx Count Records Tool > Prophecy CountRecords Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-count-records). |
| [Cross Tab](https://help.alteryx.com/current/en/designer/tools/transform/cross-tab-tool.html) | [Pivot gem](/data-analysis/gems/transform/pivot) | Pivots data on unique values of a specified column. For a full side-by-side comparison, see [Alteryx Cross Tab Tool > Prophecy Pivot Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-cross-tab). |
| [Make Columns](https://help.alteryx.com/current/en/designer/tools/transform/make-columns-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) + [WindowFunction gem](/data-analysis/gems/transform/window) + [Script gem](/data-analysis/gems/custom/script) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-make-columns). |
| [Running Total](https://help.alteryx.com/current/en/designer/tools/transform/running-total-tool.html) | [WindowFunction gem](/data-analysis/gems/transform/window) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-running-total). |
| [Summarize](https://help.alteryx.com/current/en/designer/tools/transform/summarize-tool.html) | [Aggregate gem](/data-analysis/gems/transform/aggregate) or [Deduplicate gem](/data-analysis/gems/prepare/deduplicate) or [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-summarize). |
| [Transpose](https://help.alteryx.com/current/en/designer/tools/transform/transpose-tool.html) | [SQL Statement gem](/data-analysis/gems/custom/sql-statement) | Uses pivoting logic to change data orientation. For a full side-by-side comparison, see [Alteryx Transpose Tool > Prophecy Unpivot Gem](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-transpose). |
| [Weighted Average](https://help.alteryx.com/current/en/designer/tools/transform/weighted-average-tool.html) | [Aggregate gem](/data-analysis/gems/transform/aggregate) or [Reformat gem](/data-analysis/gems/prepare/reformat) | Computes a weighted average using required expressions. For a full side-by-side comparison, see [Alteryx Weighted Average tool > Prophecy Reformat and Aggregate Gems](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-transform-tools/alteryx-weighted-average). |
## Developer
The following table lists the mapping for Alteryx [Developer tools](https://help.alteryx.com/current/en/designer/tools/developer.html).
| Alteryx Tool | Prophecy | Description |
| ------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------ | ---------------------------------------------------------------------- |
| [Base64 Encoder](https://help.alteryx.com/current/en/designer/tools/developer/base64-encoder-tool.html) | [DataEncoderDecoder gem](/data-analysis/gems/transform/encoder-decoder) | Encodes a string field using the base64 method. |
| [Download](https://help.alteryx.com/current/en/designer/tools/developer/download-tool.html) | [RestAPI gem](/data-analysis/gems/custom/rest-api) | Enriches a DataFrame by adding columns from REST API output. |
| [Dynamic Rename](https://help.alteryx.com/current/en/designer/tools/developer/dynamic-rename-tool.html) | [MultiColumnRename gem](/data-analysis/gems/prepare/multi-column-rename) | Renames multiple columns systematically. |
| [Dynamic Select](https://help.alteryx.com/current/en/designer/tools/developer/dynamic-select-tool.html) | [DynamicSelect gem](/data-analysis/gems/transform/dynamic-select) | Dynamically filters columns based on your conditions. |
| [JSON Parse](https://help.alteryx.com/current/en/designer/tools/developer/json-parse-tool.html) | [JSONParse gem](/data-analysis/gems/parse/json-parse) | Parses and converts JSON or XML into a tabular format. |
| [Dynamic Input](https://help.alteryx.com/current/en/designer/tools/developer/dynamic-input-tool.html) | [DynamicInput gem](/data-analysis/gems/custom/dynamic-input) | Run SQL queries that update automatically based on your incoming data. |
## Documentation
The following table lists the mapping for Alteryx [Documentation tools](https://help.alteryx.com/current/en/designer/tools/documentation.html).
| Alteryx Tool | Prophecy | Description |
| ----------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| [Tool Container](https://help.alteryx.com/current/en/designer/tools/documentation/tool-container-tool.html) | [Visual Containers](/data-analysis/development/studio/containers) | Divide your pipeline into different sections by visually organizing related gems. |
## Laboratory
The following table lists the mapping for Alteryx [Laboratory tools](https://help.alteryx.com/current/en/designer/tools/laboratory.html).
| Alteryx Tool | Prophecy | Description |
| ---------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------- | ---------------------------------------------------------------------- |
| [Transpose In-DB](https://help.alteryx.com/current/en/designer/tools/laboratory/transpose-in-db-tool.html) | [SQL Statement gem](/data-analysis/gems/custom/sql-statement) | Uses pivoting logic to transform data orientation within the database. |
## In-Database
The following table lists mappings for Alteryx [In-Database tools](https://help.alteryx.com/current/en/designer/tools/in-database.html).
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](/data-analysis/environment/fabrics/prophecy-fabrics); unlike Alteryx, there is no separate “In-DB” toolset or execution mode.
| Alteryx Tool | Prophecy | Description |
| ------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [Browse In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/browse-in-db-tool.html) | [Data Explorer](/data-analysis/development/runs/data-explorer/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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-browse-tool). |
| [Connect In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/connect-in-db-tool.html) | [Source gem](/data-analysis/gems/source-target/source-target) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-input-data-tool). |
| [Data Stream In](https://help.alteryx.com/current/en/designer/tools/in-database/data-stream-in-tool.html) | [Source gem](/data-analysis/gems/source-target/source-target) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-input-data-tool). |
| [Data Stream Out](https://help.alteryx.com/current/en/designer/tools/in-database/data-stream-out-tool.html) | [Target gem](/data-analysis/gems/source-target/source-target) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-in-out-tools/alteryx-output-data-tool). |
| [Filter In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/filter-in-db-tool.html) | [Filter gem](/data-analysis/gems/prepare/filter) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-prep-tools/alteryx-filter-tool). |
| [Formula In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/formula-in-db-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | 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](https://help.alteryx.com/current/en/designer/tools/in-database/join-in-db-tool.html) | [Join gem](/data-analysis/gems/join-split/join) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-join). |
| [Select In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/select-in-db-tool.html) | [Reformat gem](/data-analysis/gems/prepare/reformat) | Uses the Reformat gem to select, deselect, rename, and reorder columns. |
| [Summarize In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/summarize-in-db-tool.html) | [Aggregate gem](/data-analysis/gems/transform/aggregate) | 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](https://help.alteryx.com/current/en/designer/tools/in-database/union-in-db-tool.html) | [Union gem](/data-analysis/gems/join-split/union) | 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](/import-tool/alteryx/alteryx-to-prophecy-sql/tool-mapping/alteryx-join-tools/alteryx-union). |
| [Write Data In-DB](https://help.alteryx.com/current/en/designer/tools/in-database/write-data-in-db-tool.html) | [Table gem](/data-analysis/gems/source-target/source-target) | Writes to your default warehouse connection in a Prophecy fabric. |