COUNTRYCAR 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,
COUNTRYCAR 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
December 21, 2018, 11:34 AM
MartinY
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007