What the example shows
572 revenue lines traced through the document flow to 93 root orders. Second workflow: document families against RAR contracts, with combination candidates.
What you get
- The ebook: an 89-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (09_Root_Order.yxmd, 09b_Family_Contracts.yxmd)
- 1 batch macro
- Synthetic sample data (5 files) and an answer key, so you can check every number
- Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment
Contents
- Chapter 1Which order started this revenue?
- Chapter 2The four input files
- Chapter 3One key rule, and the starting frontier
- Chapter 4The iterative macro: one level per iteration
- Chapter 5The closure table and the lookups
- Chapter 6From GL line to item to root
- Chapter 7The family tree, the root summary and the control totals
- Chapter 8Reading the result
- Chapter 9Moving it to your system
- Chapter 10One family, one contract?
- Chapter 11Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


