What the example shows
635 lines retranslated. Rates the wrong way round, wrong rate types and rounding errors found. Second workflow: the contract liability at the close, checked for revaluation currency by currency.
What you get
- The ebook: an 82-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (15_Foreign_Currency.yxmd, 15b_CL_Not_Revalued.yxmd)
- Synthetic sample data (7 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 1Two currencies on every line
- Chapter 2The six files
- Chapter 3A rate table that works both ways round
- Chapter 4One stream of lines
- Chapter 5Every candidate rate in one lookup
- Chapter 6Recompute, and name the cause
- Chapter 7The FX difference on the contract liability
- Chapter 8Reading the result
- Chapter 9Moving it to your system
- Chapter 10The liability is not revalued
- Chapter 11Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


