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
- Chapter 1Where does the data come from?
- Chapter 2The SAP side: tables, formats and the control file
- Chapter 3Landing the extract in Snowflake
- Chapter 4Curated views: giving the text its types
- Chapter 5Connecting Alteryx to Snowflake
- Chapter 6The workflow, hop by hop
- Chapter 7The exceptions and the field reference
- Chapter 8Reading the result
- Chapter 9Moving it to your system
- Chapter 10The next extract: full plus delta
- Chapter 11Exercises
- Appendix AReference: the tables and fields
- Appendix BTool-by-tool settings
- Appendix COutput field dictionary
Look inside


