The RevRec Canvas
Book 11: Reading the change history cover

Home › Contracts and obligations

Book 11 · Alteryx workflows for SAP RAR

Reading the change history

Turning RAR's change history into an evidence trail: which contracts and POBs changed, when, why and by how much, and whether the modification flag agrees.

  • Contracts and obligations
  • Intermediate
  • 89 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

159 change rows read. Some POBs are flagged but unchanged, others changed but unflagged. Second workflow: every change matched with the approval log, and every approval with the history.

What you get

  • The ebook: an 89-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (11_Change_History.yxmd, 11b_Change_Approvals.yxmd)
  • Synthetic sample data (4 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

  1. Chapter 1What changed, when, why, and by how much
  2. Chapter 2The three files
  3. Chapter 3Clean keys first, then count
  4. Chapter 4Reason texts and labels
  5. Chapter 5Walking each POB's history
  6. Chapter 6The flag against the history
  7. Chapter 7Every row accounted for
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Was every change approved?
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 11: Reading the change history table of contents
Contents
Book 11: Reading the change history first page
First page