Skip to Content
Author's profile photo Karol Kalisz

Mixing Data from 2 Result Sets together (join, select)

This blog describes a functional and practical use of

for one use case – merge data from 2 result sets (fill a structure or append a column).

For today, only a primitive options are possible, but anyway it is a good start…

Use Case 1. Fill an Empty Structure.

The master Result Set looks like:


The slave Result Set looks like:


Selection Options:



  • Column Index in Slave is “2”, means that the “Region” will be read out.
  • Multiple Matches is set to “Collect”, means that the entry is inserted separated by ,

You have to use the component “UI5Table” for visualization, with following settings:


It means, in this setup, the table is not requesting data source directly, but is taking the shared result set after data mash-up.

Use Case 2. Append a Column from 2nd Result Set.

The master Result Set looks like:


The slave Result Set looks like:


And the result (carefully! the selection is today only on column 0 – so it works only for such simple resultsets)


and, as a result there is a combined result set from 2 data sources.

Examples of used BIAPPs:

org-scn-design-studio-community/applications · GitHub

  • SDK_DATAMIXER_P1 (the first case)
  • SDK_DATAMIXER_P2 (the second case)

This is a start only, next is:

  • extend the selection capabilities to more than one column for APPEND
  • think about right / left joins and unions
  • finalize and describe the rules for conditions

I hope someone of you will be inspired on this direction.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello Karol Kalisz,

      I was following your steps to get my datasources (SQL - BW) working together but I'm facing an issue to display the result of the resultmixer component.

      The UI5Table just make my application goes blank.

      I've also tried the new UI5 Table 2.0 but the result seems to display default value in the table.

      Is there another way to going through the resultmixer data?

      I've seen a method called SetFeedingComponent for the charts but don't find any documentation about it. Could this help my problem?

      Thank you in advance for your help.


      Tuan Nguyen Dinh

      Author's profile photo Manoj Kumar Pandey
      Manoj Kumar Pandey

      Hi Karol,

      I have a requirement where I have to merge two tables into one.

      Both the tables have same fields as you can see. Only difference is the filter.

      Left table is showing data for the selected Period(Listbox) while the right table is displaying data for " less than or equal to" the selected Period.

      The User wants to merge both datasets into one as shown in second image.

      I did this by setting '0' column width to zero in Right Table.But this is not the right way as when I apply some of the global filters then number of records in both the table gets different and then this trick fails.

      Is there any way to achieve this??

      I am using Lumira Designer 2.0 . And connection is Hana->Universe->Discovery->Designer.

      Thanks in advance.