What the example shows
The royalty base by title and period, with every revenue line in exactly one status. Second workflow: the half-year royalty statement, advances recouped and a minimum guarantee topped up, with the entry.
What you get
- The ebook: a 91-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (33_Royalty_Revenue.yxmd, 33b_Royalty_Advances.yxmd)
- Synthetic sample data (6 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 1The royalty base
- Chapter 2The data
- Chapter 3The extract and its keys
- Chapter 4The ISBN master
- Chapter 5The material, then the flag
- Chapter 6One status per line
- Chapter 7The base, the titles and the control
- Chapter 8Reading the result
- Chapter 9Moving it to your system
- Chapter 10From the base to the royalty statement
- Chapter 11Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


