Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Cooper Hall (CooperH7)
Accenture

Accenture
US
CooperH7 Member since 2012 1 post
Accenture
Posted: Feb 23, 2016
Last activity: Mar 3, 2016
Posted: 23 Feb 2016 14:48 EST
Last activity: 3 Mar 2016 16:48 EST
Closed

Removing duplicates when "Serial Number" is the same

Hi all,

We have an internal table that holds an inventory of currently available items and we want to only display the unique values(e.g. each different make/model).  The problem is that each item has a unique serial number which is preventing the report's "remove duplicate rows" functionality from just removing the duplicates.  Is there a way to disregard the serial number column?

To see attachments, please log in.
Reporting

Posted: 8 years ago
Posted: 3 Mar 2016 16:48 EST
Damien RENIER (Damien)
Ai4Process
Global Tech Enablement, Principal Instructor
Ai4Process
GB

Hi,

Not sure if this is what you want but I set the SerialNumber column Summarized as Max.

When I use my Report Definition from a Data Page, it doesn't contains any duplicate just the Max SerialNumber for each duplicated.

Damien

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice