Using the "Unique Tool" but also retaining unique single values within the data

Hi all,

I have a large dataset that I need to refine per "Parent Name" that are assigned to a particular individual, I used the "Unique Tool" with a degree of success but when I validated my data I realised the "Unique Tool" will only return a unique value if >1 record within the data.

Is there anyway of filtering down unique values but also including where there is a single value including that in the output? I have attached sample data, the first tab is the original raw data and the second tab is the expected outcome.

Thanks,

Alex.

DataExample.xlsx

Workflow

Datasets

Developer

Reporting

Output

Tips and Tricks

Help

Preparation

Data Investigation

Accepted answers

Use a summarize tool in group by mode. Don't bother with Unique.

All comments

Use a summarize tool in group by mode. Don't bother with Unique.

@AlexSimmons
I tried with the Unique tool on Column "Parent Name", and the result is same with your "PostFilter" tab in the Excel file.

Where is wrong about the Unique tool again?

0108-AlexSimmons.yxmd

Why does your output example include value 806 instead of 426 of [RecordID] ?

Thanks @apathetichell, I used your suggestion and then joined the two data sources together.

@Qiu - My actual dataset is much large and the output is as I described.

@flying008 - I wrote over the original dataset to create dummy data, that should be ignored.

Thanks,

Alex.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703