The RevRec Canvas
Book 26: Did anything change? cover

Home › Build kit

Book 26 · Alteryx workflows for SAP RAR

Did anything change?

Snapshot and regression testing: prove that a month-end copy of the RAR tables matches the live system, that two schemas hold the same columns, and that a corrected workflow changed exactly what the fix was meant to change, and nothing else.

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

What the example shows

Snapshot against live tables, and an old workflow against its fix, compared field by field. Second workflow: November's snapshot against October's for the closed periods, with every change checked against the change log.

What you get

  • The ebook: a 78-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (26_Snapshot_Regression.yxmd, 26b_Closed_Periods.yxmd)
  • Synthetic sample data (11 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 1Did anything change?
  2. Chapter 2The nine files
  3. Chapter 3Each side, counted the same way
  4. Chapter 4Live against snapshot
  5. Chapter 5The schema check
  6. Chapter 6The regression test: keys first
  7. Chapter 7The regression test: field by field
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Did the past change?
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 26: Did anything change? table of contents
Contents
Book 26: Did anything change? first page
First page