Skip to Content
0

How to Merge Ranges in HANA Calc View with or with out a Cartesian Join ?

Mar 21, 2017 at 01:58 AM

97

avatar image

Hi

I have a requirement to merge few ranges and the ranges are pretty random. Here is an example. The idea is to feed only final applicable ranges after merging.

The final result supposed to be only two ranges: 1-779 ; 850-875

How can we achieve this in HANA Calculation View? With or Without Cartesian or Self Join. We tried many approaches, but it is not working 100% in all data scenarios.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Benedict Venmani Felix Mar 21, 2017 at 04:54 PM
1

hi Satya,

Your question very vague. What are these ranges? Are they coming from two or more number of tables?

Share
10 |10000 characters needed characters left characters exceeded