Community Live

SAP HANA Basics For Developers: Part 7.8 SQLScript Map Merge

Thomas Jung
April 9, 2021

The MAP_MERGE operator is used to apply a mapper function on each row of an input table and union all intermediate results into a single result table. The operator can be a replacement for sequential FOR-loops and union patterns. In the following video, you will use the MAP_MERGE operator.

More from Hands-On SAP Dev

Open Channel on YouTube
Let's write a script together with bash, jq, and the btp CLI
DJ Adams
October 7, 2021
Embedded Steampunk
Rich Heilman
October 7, 2021
Scripting and JSON output with btp, the SAP Business Technology Platform CLI
DJ Adams
September 30, 2021
SAP Samples Spotlight: btp-extensions-unified-order-management
DJ Adams
September 27, 2021
Logging in and configuration with btp, the SAP Business Technology Platform CLI
DJ Adams
September 23, 2021
RAP - What's in it for you?
Rich Heilman
September 16, 2021
Getting started with btp, the SAP Business Technology Platform CLI
DJ Adams
September 9, 2021
Exploring SAP Graph together - Part 5
DJ Adams
July 29, 2021
Exploring SAP Graph together - Part 4
DJ Adams
July 22, 2021
Exploring SAP Graph together - Part 3
DJ Adams
July 15, 2021
ABAP - Past, Present & Future
DJ Adams
July 15, 2021
#SAPBTP Development with GitHub Copilot
Marius Obert
July 9, 2021
Exploring SAP Graph together - Part 2
DJ Adams
July 8, 2021
Exploring SAP Graph together (Livestream)
DJ Adams
July 2, 2021
Open Working
DJ Adams
June 11, 2021
GitHub mechanics for the Open Documentation Initiative
DJ Adams
June 3, 2021
Introducing the Open Documentation Initiative
DJ Adams
May 27, 2021
Developer Keynote - FRONTEND component
Thomas Jung
April 23, 2021
SAP HANA Basics For Developers: Part 14 UI5 Evolution
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 13 Audit Logging
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 12 Unit Tests
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 11 Packaging for Transport
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.11 SAPUI5 OData V4 With Create Option
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.10 SAPUI5 OData V4 with Fiori Annotations
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.9 SAPUI5 OData Deep Insert
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.8 SAPUI5 OData V2 Batch
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.7 SAPUI5 OData V2 with Create Option
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.6 SAPUI5 OData V2 with Dynamic Columns From Metadata
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.5 SAPUI5 Consume OData V2
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.4 SAPUI5 Consume REST Service via AJAX
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.3 SAPUI5 Basics
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.2 SAPUI5 and Text Bundles
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 10.1 SAPUI5 as an XSA Service
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.14 Node.js: CAP OData V4 with Exits
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.13 Node.js: Web Sockets
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.12 Node.js: Object Oriented JavaScript
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.11 Node.js: Open Source Modules
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.10 Node.js: Text Bundles
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.9 Node.js: JavaScript Basics
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.8 Node.js: Asynchronous Non-Blocking I/O
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.7 Node.js: OS and Environment Access
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.6 XSA Application Level Security
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.5 Node.js: Stored Procedures
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.4 Node.js: Async and Promises
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.3 Node.js: HANA Connectivity
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.2 Node.js: Modules and Express
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 9.1 OData V4 Services in Node.js From CAP CDS
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.8 XSODATA: OData V2 Create with Exits
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.7 XSODATA: OData V2 With Multiple Entities and Relationships
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.6 XSODATA: Creating a Simple OData V2 Service
Thomas Jung
April 13, 2021
Unsupported media, please check source url!
SAP HANA Basics For Developers: Part 8.5 XSJS SQLCC - Secondary DB Connection
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.4 XSJS Outbound HTTP Requests
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.3 Exploring JavaScript Language Features
Thomas Jung
April 13, 2021
SAP HANA Basics For Developers: Part 8.2 Debugging XSJS and Node.js
Thomas Jung
April 12, 2021
SAP HANA Basics For Developers: Part 8.1 XSJS and XSODATA
Thomas Jung
April 10, 2021
SAP HANA Basics For Developers: Part 7.11 SQLScript Performance Analysis
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.10 SQLScript Debugging
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.9 SQLScript Map Reduce
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.7 SQLScript Table Manipulation
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.6 SQLScript Anonymous Blocks
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.5 SQLScript Built-In Libraries
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.4 SQLScript Libraries
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.3 SQLScript Table UDF
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.2 SQLScript Scalar UDF
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 7.1 SQLScript Simple Procedure
Thomas Jung
April 9, 2021
Developer Keynote - CHARITY Component
Thomas Jung
April 9, 2021
SAP HANA Basics For Developers: Part 6.4 Importing Calculation Views in CAP
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 6.3 Calculation View Table Function
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 6.2 Calculation View Cube Type
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 6.1 Calculation View Dimension Type
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.8 Cross Container From Outside Our Project
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.7 Cross Container Local
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.6 Non-Container Schema Access
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.5 Structured Privilege and Roles
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.4 Tables and Views Via SQL DDL
Thomas Jung
April 8, 2021
SAP HANA Basics For Developers: Part 5.3 Table Data Configuration
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 5.2 Tables and Views Via CAP CDS
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 5.1 Database Content
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 4 Hello World
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 3 Application Server Layer
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 2 Tooling
Thomas Jung
April 7, 2021
SAP HANA Basics For Developers: Part 1 Introduction
Thomas Jung
April 6, 2021
Help Shape a New SAP HANA CAP Sample
Thomas Jung
March 22, 2021
HANA; Local Development, VCAP_SERVICES, and HDI Deployer
Thomas Jung
March 22, 2021
Help Shape A New SAP HANA CAP Sample
Thomas Jung
March 22, 2021
Developer Keynote - BRAIN component - part 1
DJ Adams
March 5, 2021
Developer Keynote - GitHub Actions
DJ Adams
February 26, 2021
Developer Keynote - EMITTER component - Messaging APIs and SAP S/4HANA Cloud events
DJ Adams
February 19, 2021
Developer Keynote - SANDBOX component part 2 - CF & K8S
DJ Adams
February 12, 2021
Developer Keynote - SANDBOX component
DJ Adams
February 9, 2021
Developer Keynote - Message Bus component
DJ Adams
January 29, 2021
SAP Business Application Studio: SAP HANA Tools with SAP Cloud Application Programming Model Project
Thomas Jung
January 15, 2021
Developer Keynote - Getting set up!
DJ Adams
January 14, 2021
SAP HANA Tooling in SAP Business Application Studio
Thomas Jung
January 12, 2021
Generating Enterprise Messaging artifact graphs with shell scripting and Graphviz - Part 4
DJ Adams
November 20, 2020
HTML5 Apps integration with SAP Cloud Platform Launchpad
Marius Obert
November 18, 2020
Generating Enterprise Messaging artifact graphs with shell scripting and Graphviz - Part 3
DJ Adams
November 12, 2020
VSCode Development Using Remote - WSL
Thomas Jung
November 10, 2020
Using Postman for API Testing with XSUAA
Marius Obert
November 9, 2020
HANA Cloud Trial Setup
Thomas Jung
November 6, 2020
Generating Enterprise Messaging artifact graphs with shell scripting and Graphviz - Part 2
DJ Adams
November 6, 2020
Building hana-opensap-cloud-2020 Part 15: Media Streaming and SAP Fiori
Thomas Jung
November 3, 2020
Generating Enterprise Messaging artifact graphs with shell scripting and Graphviz - Part 1
DJ Adams
October 30, 2020
Building hana-opensap-cloud-2020 Part 14: UI Annotations
Thomas Jung
October 27, 2020
Building hana-opensap-cloud-2020 Part 13: Complex Response Bodies and Web Sockets
Thomas Jung
October 20, 2020
Building hana-opensap-cloud-2020 Part 12: Swagger UI
Thomas Jung
October 13, 2020
Diving into Messaging on SAP Cloud Platform - Part 8: Wrapping Up
DJ Adams
October 9, 2020
Deploy SAP Cloud Application Programming Model to SAP Cloud Platform, Kyma runtime
Thomas Jung
October 6, 2020
Building hana-opensap-cloud-2020 Part 11: Customizing Express
Thomas Jung
September 29, 2020
Diving into Messaging on SAP Cloud Platform - Part 6
DJ Adams
September 24, 2020
Building hana-opensap-cloud-2020 Part 10: Service Bootstrapping
Thomas Jung
September 22, 2020
Diving into Messaging on SAP Cloud Platform - Part 5
DJ Adams
September 18, 2020
Building hana-opensap-cloud-2020 Part 9: Service Handlers
Thomas Jung
September 15, 2020
Diving into Messaging on SAP Cloud Platform - Part 4
DJ Adams
September 11, 2020
Building hana-opensap-cloud-2020 Part 8: SQLScript
Thomas Jung
September 8, 2020
Building hana-opensap-cloud-2020 Part 7: Calculation Views
Thomas Jung
September 1, 2020
Diving into Messaging on SAP Cloud Platform - Part 3
DJ Adams
August 28, 2020
Building hana-opensap-cloud-2020 Part 6: Cross Container
Thomas Jung
August 25, 2020
Diving into Messaging on SAP Cloud Platform - Part 2
DJ Adams
August 21, 2020
Building hana-opensap-cloud-2020 Part 5: Cross Schema Access
Thomas Jung
August 20, 2020
Building hana-opensap-cloud-2020 Part 4: Transactional Tables
Thomas Jung
August 18, 2020
Diving into Messaging on SAP Cloud Platform - Part 1 - Addendum
DJ Adams
August 17, 2020
Diving into Messaging on SAP Cloud Platform - Part 1
DJ Adams
August 17, 2020
Building hana-opensap-cloud-2020 Part 3: Master Data
Thomas Jung
August 13, 2020
Building hana-opensap-cloud-2020 Part 2: Designing the Data Model
Thomas Jung
August 11, 2020
Building hana-opensap-cloud-2020 Part 1: Project Setup and First DB Build
Thomas Jung
August 4, 2020
A recursive reduce() and other JS function explorations
DJ Adams
July 30, 2020
SAP Cloud Application Programming model resources with Iwona Hahn
DJ Adams
July 29, 2020
Reviewing ABAP Open Source Projects
Thomas Jung
July 28, 2020