Skip to Content

Merging two crosstabs in Lumira 2.0 Designer

May 04 at 12:40 PM


avatar image

Hi Experts,

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

merge.png (68.7 kB)
merge2.png (79.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
May 04 at 12:55 PM

This is what worked in Design Studio - see but I am not sure if it will work in Lumira Designer.

Another idea is to blend back in Lumira Discovery and then bring it into Designer.

What is your data source?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Data Source/Data Flow is ----> Hana->Universe->Discovery->Designer

The problem here is that both the tables has same Measures, and I have to apply different filter conditions on them.