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
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