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.
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.
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
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.
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.