Summarize Tool Query

I'm using the Summarize Tool to isolate the earliest instances of a person in a set of data. I want to show an unsummarized value from another column but am only able to SUM, AVERAGE etc. that value. Does anyone know a way I can generate the bottom table from the one above it?

Person	Date	Value
1	1/01/2016	3
1	10/01/2016	7
2	2/01/2016	9
2	15/01/2016	2
3	20/01/2016	7
3	2/02/2016	1

Person	Min Date	Value
1	1/01/2016	3
2	2/01/2016	9
3	20/01/2016	7

Thank you in advance for your help.

Best,

DHB.

Tips and Tricks

Accepted answers

jdunkerley79

I would suggest you try using a sample tool grouped by Person to pick the first element:

Sample attached

First Sample.yxmd

All comments

DataBlender

Hi @DHB, you'll need to join the results of your summarize back on to your original dataset using person and date (see attached).

Summarize Min Date.yxmd

jdunkerley79

I would suggest you try using a sample tool grouped by Person to pick the first element:

Sample attached

First Sample.yxmd

tom_montpool

What you're describing is exactly what the Unique tool does...in your case, Sort your input on the date field and then configure the Unique tool to take the unique Person.

The Unique tool uses the sort order of the input and takes the full record of the first instance of each unique value.

Here's the help for the tool -- Unique

DHB

Thank you all for the variety of solutions, I really appreciate you taking the time to help me. The sample tool worked best in my case. After isolating the first record I ran a formula, the result of which I was able to transpose to all the other rows.

Thansk again,

DHB

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703