Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Adding Values for "Missing" Dates

I've got an XML recordset with non-consecutive months and cooresponding data values for those months. I need to create a recordset with consecutive months, the values for the months to be added will be taken from the most recent month for while I have a data value, like so:

Original Table New Table

Date Value Date Value

09/01/2005 1735 09/01/2005 1735

10/01/2005 1735

11/01/2005 1735

12/01/2005 1735

01/01/2006 1760 01/01/2006 1760

02/01/2006 1829 02/01/2006 1829

03/01/2006 1829

04/01/2006 1829

05/01/2006 1856 05/01/2006 1856

06/01/2006 1856

07/01/2006 1856

Any ideas how to do this?

David

Former Member
replied

The Union action block will take the two Rowsets/Rowset from your separate SQL query blocks and turn it into Rowsets/Rowset/Rowset - which is what the Time Interpolator is expecting.

Regards,

Jeremy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question