Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 21, 2017 at 04:54 PM

    hi Satya,

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

    Add comment
    10|10000 characters needed characters exceeded