1.3 Alteryx Native File Formats & Workflow Packaging

Quick Answer: Alteryx uses five core native file extensions: .yxmd (standard workflow file containing XML tool definitions without data), .yxmc (macro workflow for modular reusability), .yxwz (analytic app workflow with wizard UI), .yxdb (proprietary binary database format for maximum read/write performance), and .yxzp (packaged zip archive containing workflows and all linked dataset assets created via File -> Export Workflow).

Understanding Alteryx file types is essential for both development architecture and passing the Core certification exam. The exam regularly tests your ability to distinguish between workflow logic files, interactive applications, high-performance database extracts, and distribution packages.

---

Alteryx Native File Extensions Matrix

---

Detailed Analysis of Alteryx File Types

+-----------------------------------------------------------------------------+
|                      ALTERYX WORKFLOW ECOSYSTEM                             |
+-----------------------------------------------------------------------------+
| [.yxmd / .yxmc / .yxwz] (XML Layout & Tool Configs)                         |
|         |                                                                   |
|         +---> Points to External Data: [.csv / .xlsx / .yxdb]               |
|         |                                                                   |
|         +---> Exported via [File -> Export Workflow]                        |
|                   |                                                         |
|                   v                                                         |
|               [.yxzp] (Self-Contained Bundled ZIP Archive)                  |
+-----------------------------------------------------------------------------+

1. .yxmd — Alteryx Workflow

The .yxmd file is the fundamental building block of Designer. It is an uncompressed XML file that describes the visual workflow layout, tool configurations, tool annotations, connection paths, and runtime parameters.

<!-- Sample .yxmd XML Snippet -->
<AlteryxDocument yxmdVer="2024.1">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="54" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <File>C:\Data\Transactions.csv</File>
        </Configuration>
      </Properties>
    </Node>
  </Nodes>
</AlteryxDocument>

Critical Concept: A .yxmd file never embeds raw data (with the sole exception of static data typed into a Text Input tool). If you email a .yxmd file referencing C:\Data\Transactions.csv to a coworker, their workflow will throw a missing file error unless the data file is also provided or packaged.

2. .yxmc — Alteryx Macro

A macro is a workflow wrapped into a single reusable tool that can be inserted into other workflows. Macros have the .yxmc extension and utilize special interface tools:

• Macro Input: Defines incoming data stream schemas.
• Macro Output: Defines egress anchors.
• Control Parameter: Drives Batch Macros by executing once per control record.
• Standard, Batch, and Iterative: Standard macros execute once; Batch macros loop through records; Iterative macros loop until a condition is satisfied.

3. .yxwz — Alteryx Analytic App

An Analytic App is a workflow that includes Interface Tools (e.g., Drop Down, Text Box, File Browse, Check Box, Radio Button) enabling end-users to execute parameterized logic without seeing the underlying canvas.

• When an app is opened in Designer, clicking the Magic Wand icon runs the application interface.
• Apps can be published to the Alteryx Server / Gallery for self-service web execution.

4. .yxdb — Alteryx Database File

The .yxdb format is Alteryx’s proprietary binary table format. It is engineered specifically to maximize throughput in Designer:

• Zero Parsing Overhead: Data is stored in memory-ready columnar binary format. Reading a .yxdb requires no type conversion or string parsing.
• Lossless Metadata: Retains exact Alteryx data types (Int16, FixedDecimal(19,2), V_WString, SpatialObj, DateTime) without type guessing.
• Built-in Compression: Uses intelligent columnar compression (often 50–80% smaller than equivalent CSVs or Excel spreadsheets) with zero decompression CPU bottleneck.
• No Row Limits: Unlike Excel (1,048,576 rows) or Microsoft Access (2GB), .yxdb files support multi-million row datasets.
• Spatial Indexing: Embedded spatial objects are indexed for rapid spatial matching and bounding box joins.

5. .yxzp — Alteryx Workflow Package

A .yxzp file is a compressed zip package containing an Alteryx workflow (.yxmd, .yxmc, or .yxwz) along with all linked input files, reference tables, macros, and directory assets.

---

Step-by-Step: Exporting Workflow Packages (.yxzp)

When distributing workflows to colleagues or packaging assignments for grading, exporting a .yxzp ensures all file dependencies remain intact.

EXPORT WORKFLOW PACKAGE PROCEDURE
+-----------------------------------------------------------------------------+
| 1. Open active workflow in Designer                                         |
| 2. Navigate to: File -> Export Workflow (or Options -> Export Workflow)     |
| 3. In Export Workflow Dialog:                                               |
|    - Review Asset List (Input CSVs, Excel files, Macros, Images)            |
|    - Check/Uncheck specific assets to bundle                                |
| 4. Specify Package Name and Destination Directory (.yxzp)                   |
| 5. Click Save / Export -> Designer packages all assets and converts paths   |
+-----------------------------------------------------------------------------+

Automatic Path Translation: When Designer unpacks a .yxzp file on another user's computer, it extracts the assets into a local folder and automatically converts all input file paths to relative paths (.\Data\Transactions.csv), preventing broken connection errors.

---

Changing Workflow Types in Designer

You can convert a standard .yxmd workflow into an Analytic App (.yxwz) or Macro (.yxmc):

1. Click on a blank area of the canvas.
2. In the Configuration Window, select the Workflow tab.
3. Under Type, choose between:
   • Standard Workflow (.yxmd)
   • Analytic App (.yxwz)
   • Standard Macro (.yxmc)
   • Batch Macro (.yxmc)
   • Iterative Macro (.yxmc)

Exam Trap: Dropping an Interface Tool (such as a Drop Down or File Browse) onto a .yxmd canvas will automatically change the workflow type to an Analytic App (.yxwz) unless manually configured.