October 28, 2005, 04:13 PM
cyclonegiggHow to get rid of the duplicates?
Ok, I have a report that has some duplicates. How can I get rid of the duplicates and remain with the unique rows using WebFOCUS.
i.e: If I have,
NAME |DEPT
Mike |...........
Mike |...........
I want to get rid of the other Mike and remain with one.
October 31, 2005, 01:03 PM
cburttAdd another processing step before printing the report that SUMs the rows BY NAME. The single summary row for each <name> will contain, by default, the last encountered value of each of <name>'s alpha fields and the sums of all <name>'s numeric fields. For alpha fields you can override this with the "FST." prefix operator. If you want the SUMed row to contain something other than the default, then use other prefix operators or duplicate the numeric fieldd into DEFINE fields that perform the desired numeric->alpha conversion and combine that with FST., LST., etc., at output time.
HOLD/SAVE this the output from this SUM process and run your report from it.