The RevRec Canvas
Book A: Where the data comes from: SAP to Snowflake to Alteryx cover

Home › Build kit

Book A · Alteryx workflows for SAP RAR

Where the data comes from: SAP to Snowflake to Alteryx

Follow RAR data from the SAP extract, through a Snowflake landing layer and curated views, into Alteryx. Count it at every hop against the control SAP wrote, find the chunk that never arrived and the one that arrived twice, and keep a reference of the tables and fields the series works with.

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

What the example shows

An SAP extract followed through Snowflake into Alteryx and counted at every hop. A chunk that never arrived and a chunk loaded twice, found. Second workflow: October's extract plus November's delta, checked key by key against a full extract, no Snowflake needed.

What you get

  • The ebook: a 76-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (A_Data_Lineage.yxmd, Ab_Delta_Extract.yxmd)
  • Synthetic sample data (10 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 1Where does the data come from?
  2. Chapter 2The SAP side: tables, formats and the control file
  3. Chapter 3Landing the extract in Snowflake
  4. Chapter 4Curated views: giving the text its types
  5. Chapter 5Connecting Alteryx to Snowflake
  6. Chapter 6The workflow, hop by hop
  7. Chapter 7The exceptions and the field reference
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10The next extract: full plus delta
  11. Chapter 11Exercises
  12. Appendix AReference: the tables and fields
  13. Appendix BTool-by-tool settings
  14. Appendix COutput field dictionary

Look inside

Book A: Where the data comes from: SAP to Snowflake to Alteryx table of contents
Contents
Book A: Where the data comes from: SAP to Snowflake to Alteryx first page
First page