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     (CLOSED)only display multiple parts
Go
New
Search
Notify
Tools
Reply
  
(CLOSED)only display multiple parts
 Login/Join
 
Platinum Member
posted
I have a file with part numbers, and some parts are showing multiple times in the database. I only want to display the parts in my output if there are more than one occurence of that part.
For example the table may look like:
Part Qty
6203 100
6203 400
6204 200
6205 300
Only both instances of 6203 should display in the output.
Can someone tell me the most efficient way to achieve this?

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


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
 
Posts: 116 | Registered: April 23, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Try something like this -
TABLE FILE CAR
  SUM COMPUTE COUNTER/I9 = CNT.MODEL; NOPRINT
   BY COUNTRY
   BY CAR
PRINT MODEL
   BY COUNTRY
   BY CAR
WHERE TOTAL COUNTER GT 1
END

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5601 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Worked perfectly, thank you.


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
 
Posts: 116 | Registered: April 23, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
CLOSED


Prod: WebFocus 7.7.3 Win 2003
Dev: WebFocus 7.7.3 Win 2003
 
Posts: 116 | Registered: April 23, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
To add CLOSED to your title, you can edit your original post in the thread.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (CLOSED)only display multiple parts

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