Focal Point
[CLOSED]Move data up when there is null data using ACROSS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5877051386

July 19, 2016, 03:42 PM
hainguyen
[CLOSED]Move data up when there is null data using ACROSS
Hi all,
I need help in this case:
My code is
 
TABLE FILE SQLOUT
PRINT
	BATCH_TIME AS 'TIME'
	BATCH_GRADE AS 'GRADE'
ACROSS 	REACTOR
END	
 

The output is:
 
REACTOR
R601               R604              R308        
TIME        GRADE  TIME       GRADE  TIME    GRADE
2016/06/01  K38    
                   2016/06/01 K36   
                                     2016/06/02K35
2016/06/03  K38    
                   2016/06/04 K36                           
 

Record of each reactor is displayed in each line. How can I move these records go up so it can fill the blank lines like below:
 
REACTOR
R601             R604              R308        
TIME       GRADE TIME       GRADE TIME       GRADE
2016/06/01 K38   2016/06/01 K36   2016/06/02 K35
2016/06/03 K38   2016/06/04 K36                   
 

Thanks in advance.

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 7.7.03
Windows, All Outputs
July 19, 2016, 07:57 PM
Dan Satchell
Replace PRINT verb with SUM, or add SET ACROSSPRT = COMPRESS before the TABLE request.


WebFOCUS 7.7.05