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] Aggregate Search in Magnify
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Aggregate Search in Magnify
 Login/Join
 
Platinum Member
posted
Hi,

I am working on Magnify and i created an indexing procedure which has multiple values for a BY FIELD.
So i learned that i can use aggregate search in Magnify.

I tried to use mentioned in the manual as below ,but of no use.
https://infocenter.information...source%2Ftopic14.htm

Here is what i did.

  
TABLE FILE DEMOFILE

---
COMPUTE XFIELD = IF XFIELD1 EQ 'THIS' THEN XFIELD2 ELSE XFIELD3;
-*This XFIELD has multiple values for X_ID and i want to make this an aggregate field.

XFIELD AS 'M3A_XFIELD'
XFIELD AS 'SA_XFIELD'
---
BY X_ID
END

I made XFIELD as Multiple category as mentioend in the manual and then made it search aggregate.

Still after indexing,when i search i get only one value in the search result.

I couldn't find any other resource regarding this other than the above link.

Any help is highly appreciated.

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


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 208 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
srajeevan

If this is still an question, please open a case with techsupport.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1603 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
It looks like you're using the same field twice, AS different names.
Shouldn't
"XFIELD AS 'M3A_XFIELD'
 XFIELD AS 'SA_XFIELD'"
be:
"XFIELD AS 'M3A_XFIELD'
 YFIELD AS 'SA_XFIELD'" ?

Or, alternatively:
---
BY XFIELD AS 'M3A_XFIELD'
BY YFIELD AS 'SA_XFIELD'
---


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 3020 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Aggregate Search in Magnify

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