The RevRec Canvas
Book 21: In-database RAR cover

Home › Build kit

Book 21 · Alteryx workflows for SAP RAR

In-database RAR

Running Book 2’s RAR-to-GL tie-out inside Snowflake with the In-DB tools: the joins and summaries stay in the database, and only the exceptions come back to your PC.

  • Build kit
  • Advanced
  • 54 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

The tie-out pushed down to the database, with only the exceptions brought back.

What you get

  • The ebook: a 54-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (21_In_Database_Tie_Out.yxmd, 21_Load_to_Snowflake.yxmd)
  • Synthetic sample data (3 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 1Book 2's tie-out, inside the database
  2. Chapter 2Creating the In-DB connection
  3. Chapter 3The three tables
  4. Chapter 4Loading the tables
  5. Chapter 5The RAR side, in SQL
  6. Chapter 6The GL side and the comparison
  7. Chapter 7Write back, stream out only what you need
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 21: In-database RAR table of contents
Contents
Book 21: In-database RAR first page
First page