Workflow help

[aparna0208]

Hi,

Need some help!

I have a dataset where a contact could be dually registered and will have two rows and some cases just one registration. I want my output to include the contacts that are dually registered. Is there a way that I could do this? Thanks in advance

For example

Rep ID            Name                    Registration

12345             Bob Smith               RIA

12345             Bob Smith                BD

78456             Williams                   RIA

6789               Shane                      RIA

8765               Phil                           BD

8765               Phil                           RIA

[DawnDuong · Accepted solution]

Hi @aparna0208 

You can try using the Summary tool, Group by the RepID and count the number of occurence.

Dawn.

[ArtApa · Accepted solution]

Hi @aparna0208 - This is how you can achieve the desired output:

[aparna0208]

Awesome, it worked. Thank you so much:) @ArtApa 

[aparna0208]

Thanks a lot for your inputs:) @DawnDuong