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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Sort Across Question

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Sort Across Question
 Login/Join
 
Guru
posted
I have a table for Store License. Table Lay out is as follows:
  
Store    License
1        ABC
1        EDG
2        BCD
2        KJK
3        LKM
4        KJI
4        IUY
4        BUY

I Want to be able to Prsent this information as

Store
1        ABC        EDG
2        BCD        KJK
3        LKM
4        KJI        IUY        BUY


Is there a way to accomplish this?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Expert
posted Hide Post
Here's an example with the CAR file - I *think* you can't avoid doing it in two steps.

TABLE FILE CAR
SUM
COUNTRY NOPRINT
BY COUNTRY
BY BODYTYPE
ON TABLE HOLD AS H001
END

DEFINE FILE H001
BODYCOUNT/I4 = IF COUNTRY EQ LAST COUNTRY THEN BODYCOUNT + 1 ELSE 1;
END

TABLE FILE H001
SUM
BODYTYPE
ACROSS BODYCOUNT NOPRINT
BY COUNTRY
END


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Guru
posted Hide Post
Thank you sir!


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Platinum Member
posted Hide Post
Hey Francis/Arif,

One pass is doable.

The problem with the CAR table is it's a hierarchical FOCUS table so each COUNTRY only exists physically once in the top segment so the "LAST" function only sees it once and the counter doesn't work. Adding "...(IF BODYTYPE EQ LAST BODYTYPE THEN BODYCOUNT ELSE BODYCOUNT + 1) ELSE 1;" solves that.

DEFINE FILE CAR
BODYCOUNT/I4 = IF COUNTRY EQ LAST COUNTRY THEN (IF BODYTYPE EQ LAST BODYTYPE THEN BODYCOUNT ELSE BODYCOUNT + 1) ELSE 1;
END
TABLE FILE CAR
SUM BODYTYPE AS ''
ACROSS BODYCOUNT NOPRINT
BY COUNTRY AS ''
ON TABLE SET PAGE NOPAGE
END


David

This message has been edited. Last edited by: DavSmith,



In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle
 
Posts: 161 | Location: Dallas, TX | Registered: February 20, 2009Report This Post
Virtuoso
posted Hide Post
This also:

  
-* File Arif01.fex
TABLE FILE CAR
LIST BODYTYPE
BY COUNTRY
ON TABLE HOLD
END
TABLE FILE HOLD
SUM BODYTYPE
BY COUNTRY
ACROSS LIST NOPRINT
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 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] Sort Across Question

Copyright © 1996-2020 Information Builders