Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Rotating data in/out of a table by columns
Go
New
Search
Notify
Tools
Reply
  
Rotating data in/out of a table by columns
 Login/Join
 
<jrusse>
posted
I'm new to Focus (and Query Languages in general). I am attempting to create a table that maintains 60 days worth of data for each employee ID as follows:

ID Day(-59) Day(-58) ...... Day(0)

Each day, I want to roll off the Day(-59) and roll on a new Day(0) and then have all intermediate days roll back another day. I am working in Standard Focus on an OS/390 mainframe. I have contemplated using the MATCH command to accomplish adding a column, but I have not figured out how to remove the Day(-59) column from the file. Furthermore, I have not figured out how to move the data under an column in the middle back to a previous day (for instance Day(-57) would now become Day(-58)).

Any suggestions would be appreciated.
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I would pre-process the data something like this..
TABLE FILE X
SUM VALUE BY ID BY HIGHEST DAY
ON TABLE HOLD
END
DEFINE FILE HOLD
NEWVALUE=IF ID NE LAST ID THEN 0 ELSE LASTVALUE ;
LASTVALUE=VALUE;
END
-* MAKE UP THE DISPLAY REPORT ..SAMPLE
TABLE FILE HOLD
PRINT NEWVALUE
BY ID BY DAY
END
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Rotating data in/out of a table by columns

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.