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] Transforming rows into columns by row value
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Transforming rows into columns by row value
 Login/Join
 
Member
posted
Hi All,
i need a help
I have records in the database like this

country_id dealer_cost

1000 200
1000 300
1000 400
1111 200
1111 300
1111 400
2222 200
2222 300
2222 400
i want the records like this each country_id below i want dealer_cost and no space allowed

1000 1111 2222

200 200 200
300 300 300
400 400 400

Thanks in advance.

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


WebFOCUS 7.1
Windows
HTML, PDF,Excel
 
Posts: 10 | Registered: February 25, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
SUM DCOST ACROSS COUNTRY maybe? You would have to come up with a recordcounter or some such thing otherwise you end up with just 1 line. Alternatively, upgrade to 77 release, and use the new ACROSSPRT=COMPRESSED setting while doing PRINT ACROSS.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Technique courtesy of an earlier post by Tony A:

TABLE FILE CAR
 LIST DEALER_COST
 BY COUNTRY
 ON TABLE HOLD
END
-*
TABLE FILE HOLD
 SUM DEALER_COST AS ''
 BY LIST NOPRINT
 ACROSS COUNTRY AS ''
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Solved
Thanks a lot Dan Satchell
The code helped me to solve my problem


WebFOCUS 7.1
Windows
HTML, PDF,Excel
 
Posts: 10 | Registered: February 25, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Transforming rows into columns by row value

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