2 Replies Latest reply: Feb 23, 2017 3:35 AM by Elena Prandoni RSS

    How to reduce ranges fo dates.. with a complication

    Elena Prandoni


      I have this problem (see attached data):

      there is a table with ID and a dimension (C_QUAL) with some ranges of validity dates, where dates, typically, are consecutive. I would like to reduce the number of range choosing the min and the max date for every ID & C_QUAL.

      The complication is that some dates are not consecutive: in this case (in red in the file), when the end date of the prevoius record is NOT the start date-1 of the successive record, I have to create a new range, even if C_QUAL is the same.

      Is there a simple solution?