Partitioning Data Output
This page explains how to partition your data output in the Alteryx Analytics Cloud.
You can partition your data in the following ways:
By Column Values
Divide data into partitions based on a specific column. For example splitting transaction data by quarters (Q1, Q2, etc.).
You can customize partition names using prefixes, suffixes, or unique values derived from the column used for partitioning.
Customizing Data in Partitions
Full Data: All columns are included in the partitioned output.
Drop Partition Column: Exclude the column used for partitioning from the final output.Example: If dividing by quarter, the "Quarter" column can be excluded from output.
Writing the Data
You can write partitioned data to files or tables.
File Output
Supported formats include:
Excel
- Tabs (Sheets): Write partitions to individual tabs in a workbook.
File Download and Cloud Storage
File Download
Excel: Multiple tabs in a single workbook – no change in behavior.
Cloud Storage
Supported for ADS, AWS, Azure, etc. Behavior is unchanged – write single or multiple files as required.
Limitations
Output works with 500 partitions, but exceeding this limit causes the job to fail with the same error.
Column names containing pipe (|) character are not supported.