Skip to main content
Contact a Moderator

Discussion

4
Replies
2072
Views
 Vamshi Krishna Kassety (VamshiIPA)
IPA
Architect
IPA
AU
VamshiIPA Member since 2015 16 posts
IPA
Posted: July 1, 2015
Last activity: July 28, 2015
Posted: 1 Jul 2015 3:42 EDT
Last activity: 28 Jul 2015 5:46 EDT
Closed

Get Unique results

Hi All,

 

I want to have a RD which would return me list of unique Manager Names from Emp table. 

Here is the Table EMP

Emp Name  ||  Emp Age  || EMP Manager

ABC       ||  22    ||   XYZ

SDF       ||  22    ||   XYZ

QWE      ||  22    ||   EDF

RD Should return

 

XYZ

EDF

Can we do this in RD?

 

Thanks in advance

      

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 1 Jul 2015 8:39 EDT
Teng Hao Chua (chuat)
PEGA
Global Tech Enablement, Senior Instructor
Pegasystems Inc.
SG

Have you tried the "Remove duplicate rows" option in the Query tab of the report definition rule form?
Posted: 6 years ago
Posted: 16 Jul 2015 4:39 EDT
Premkumar Ganesan (PremkumarG)
cognizant

cognizant
NL

Hi CHUAT/Vamsi,


I dont see the first and second row are duplicate.. Then how come you achieve this.?!
Posted: 6 years ago
Posted: 28 Jul 2015 5:46 EDT
Sai Phaneendra (SaiYakkali)
Coforge Tech
Technical Architech
Coforge Tech
US

In this requirement he need only Manager Name, so Remove Duplicate Records will show only unique records.

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