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     [SOLVED] HOLD DATA USING ACROSS COLUMNS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] HOLD DATA USING ACROSS COLUMNS
 Login/Join
 
WF World
Silver Member
posted
Hi,
I'm trying to hold data using ACROSS COUNTRY and uisng COLUMNS command to sort but when I print the hold data I'm getting extra character appended. Below is my code

 TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1 FORMAT FOCUS
END

TABLE FILE H_TEMP1
PRINT
*
END


Result come with SAL appended to country:

SALITALY SALENGLAND SALFRANCE SALW GERMANY SALJAPAN

How do I avoid SAL infront of country.

This message has been edited. Last edited by: WF World,


WebFOCUS 8.1.03
Windows, Linux All Outputs
 
Posts: 46 | Location: India | Registered: August 18, 2011Report This Post
Tamra
Guru
posted Hide Post
WF World,

This is the expected default results for holding report data when using an ACROSS.

Use the ASNAMES syntax

ON TABLE SET ASNAMES ON

OR

SET ASNAMES = {ON|OFF|MIXED|FOCUS|FLIP}

ON
Uppercases the literal specified in an AS phrase and propagates it as the field name in the HOLD Master File. Creates names for ACROSS fields that consist of the AS name value concatenated to the beginning of the ACROSS field value and controls the way ACROSS fields are named in HOLD files of any format.


Happy Holidays.

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
WF World
Silver Member
posted Hide Post
quote:
concatenated to the beginning of the ACROSS field value and controls the way ACROSS fields are named


Hi Tamra,
Thanks for your response on this request.
I've already tried using SET ASNAMES=ON before but it didn't work for me.

 
SET ASNAMES=ON

TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1 FORMAT FOCUS
END

TABLE FILE H_TEMP1
PRINT
*
END


WebFOCUS 8.1.03
Windows, Linux All Outputs
 
Posts: 46 | Location: India | Registered: August 18, 2011Report This Post
Tony A
Expert
posted Hide Post
quote:
I've already tried using SET ASNAMES=ON before but it didn't work for me.

You need to read what Tamra wrote in full as she is saying that this is expected behaviour (as well as being documented - she included the quote from the documentation).

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
WF World
Silver Member
posted Hide Post
quote:
SALITALY SALENGLAND SALFRANCE SALW GERMANY SALJAPAN


it worked...

Thanks Tamra for your help 
  
SET ASNAMES=ON

TABLE FILE CAR
SUM
SALES AS ''
BY CAR AS ''
ACROSS COUNTRY AS '' COLUMNS 'ITALY' AND 'ENGLAND' AND 'FRANCE' AND 'W GERMANY' AND 'JAPAN'
ON TABLE HOLD AS H_TEMP1
END

TABLE FILE H_TEMP1
PRINT
*
ON TABLE PCHOLD FORMAT PDF
END


WebFOCUS 8.1.03
Windows, Linux All Outputs
 
Posts: 46 | Location: India | Registered: August 18, 2011Report This Post
J.L. Hinds
Gold member
posted Hide Post
May be an easier way but here is a fast way

TABLE FILE H_TEMP1
PRINT
E01
E02 AS 'ITALY'
E03 AS 'ENDGLAND'
E04 AS 'FRANCE'
E05 AS 'W GERMANY'
E06 AS 'JAPAN'
END


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 74 | Registered: December 23, 2013Report This Post
WF World
Silver Member
posted Hide Post
Hi Hinds,
Thanks for the reply.
My across value changes dinamically. I'll read it in a variable and then provide it as below

ACROSS COUNTRY AS '' COLUMNS &COLVAL11


Now its working fine.

I really appriciate your help on this. Thanks


WebFOCUS 8.1.03
Windows, Linux All Outputs
 
Posts: 46 | Location: India | Registered: August 18, 2011Report This Post
Waz
Expert
posted Hide Post
Hi WF World,

If your question has been answered, please add [SOLVED] or [CLOSED] to the title of your first post.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     [SOLVED] HOLD DATA USING ACROSS COLUMNS

Copyright © 1996-2020 Information Builders