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     [SOLVED] Display with ;
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Display with ;
 Login/Join
 
Member
posted
Hi,

I have a fex

TABLE FILE CAR
PRINT COUNTRY CAR
END

COUNTRY CAR
ENGLAND JAGUAR
ENGLAND JENSEN
ENGLAND TRIUMPH
JAPAN DATSUN
JAPAN TOYOTA
ITALY ALFA ROMEO
ITALY MASERATI
W GERMANY AUDI
W GERMANY BMW
FRANCE PEUGEOT


I would like display in this format,

COUNTRY CAR
ENGLAND JAGUAR;JENSEN;TRIUMPH
JAPAN DATSUN;TOYOTA
ITALY ALFA ROMEO;MASERATI
W GERMANY AUDI;BMW
FRANCE PEUGEOT

Thanks for you help.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2
 
Posts: 2 | Registered: March 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
One possible way to accomplish:
DEFINE FILE CAR
DUMMY /A100V = IF COUNTRY EQ LAST COUNTRY THEN DUMMY || ';' || CAR ELSE CAR;
END
TABLE FILE CAR
SUM DUMMY AS ''
BY COUNTRY AS ''
END
-RUN

But need to have your data already in the right order. Otherwise you may need a pre-step to order them according to the BY field.

Note : use the code tag when posting sample data and/or code. It's the last one on the ribbon
</>


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Thank you very much,MartinY, it works


WebFOCUS 8.2
 
Posts: 2 | Registered: March 17, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display with ;

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