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

[AlexSimmons]

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.

[apathetichell · Accepted solution]

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

[Qiu]

@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?

[flying008]

@AlexSimmons 

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

[AlexSimmons]

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.