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.
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,
WF8206,Windows 7,8,10 HTM,PDF,EXCEL
September 24, 2019, 01:14 PM
FP Mod Chuck
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
September 29, 2019, 02:24 PM
Doug
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. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206