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] Concatenate values in two rows to one row.
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Concatenate values in two rows to one row.
 Login/Join
 
Platinum Member
posted
I have this requirement, below is the example data:
 
ID      Description
001     AAA
001     BBB
002     CCC
002     DDD
003     EEE
 

I need to output it like:
 
ID      Description
001     AAA BBB
002     CCC DDD
003     EEE
 

How can I concatenate the description of the same ID in one row ?
Thanks.

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


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Reply With QuoteReport This Post
Master
posted Hide Post
Try below code. It will help you.
APP PATH IBISAMP
-******** Ensure data is sorted on right column. Here it is COUNTRY. In your case it should be ID column *********
TABLE FILE CAR
PRINT
COMPUTE ALL_CAR/A200V = IF COUNTRY EQ LAST COUNTRY THEN ALL_CAR | ' , ' | CAR ELSE CAR; AS 'ALL CARS'
COMPUTE A_CAR_LEN/I3=ARGLEN(200,ALL_CAR,'I3'); NOPRINT
BY COUNTRY 
BY TOTAL HIGHEST 1 A_CAR_LEN NOPRINT
END

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Ram, this works perfectly.


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Concatenate values in two rows to one row.

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