Consult Import and convert for uploading batches of
.yxmd files and interpreting conversion reports..yxmd file parsing
Collect workflows and dependencies
Gather
.yxmd files plus any macro .yxmc dependencies and data connections exported according to your governance policy. Remove embedded credentials from files before upload; rebind secrets in Planasonix.Upload and choose options
In the Alteryx import profile, select whether to inline macros on first pass or preserve macro boundaries as subgraphs when supported.
Tool to node mapping
| Alteryx tool (examples) | Planasonix direction |
|---|---|
| Input Data / Connect In-DB | Source nodes with SQL or driver metadata |
| Formula, Filter, Select | Column and row transforms |
| Join, Union | Join and union nodes |
| Summarize | Aggregation node |
| Output Data | Destination node |
| Browse (developer) | Ignored or converted to preview annotations |
Formula and data types
Alteryx Formula expressions use Alteryx-specific functions and type coercion rules.Function parity
Function parity
Functions like
DateTimeParse, IFNULL, and string cleaners may translate to SQL or native expressions. When no direct mapping exists, the importer inserts a placeholder SQL block—replace it with tested logic.Locale and types
Locale and types
Date, fixed decimal, and string width behavior can differ from your warehouse. Run preview steps on representative samples after conversion.
Macro handling
Standard macros encapsulate reusable tool chains.- Standard macros
- Batch and iterative macros
Planasonix may expand macros into nested subgraphs or reusable pipeline components depending on product version. Keep macro inputs documented so you can map control parameters to variables.
In-database vs standard workflows
In-DB streams should map closer to warehouse-native SQL. Standard workflows that mix local temp files and engine execution may need restructuring for cloud runtimes without local disk assumptions.Dynamic inputs (wildcard paths, directory tools) should become parameterized sources or file triggers in orchestration rather than hard-coded samples.
Related topics
Row transforms
Filters, sorts, and sampling after import.
Advanced nodes
Python and extension points for complex Alteryx logic.