Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Move data up when there is null data using ACROSS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Move data up when there is null data using ACROSS
 Login/Join
 
hainguyen
Platinum Member
posted
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
 
Posts: 125 | Registered: June 17, 2013Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Replace PRINT verb with SUM, or add SET ACROSSPRT = COMPRESS before the TABLE request.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Move data up when there is null data using ACROSS

Copyright © 1996-2020 Information Builders