Summarize Tool Query

[DHB]

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.

[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).

[jdunkerley79 · Accepted solution]

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

Sample attached

[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