Subset functions: identify earliest Date(s) in a field?

Valentina · June 10, 2014 9:47AM

Hi all,

Assume I have 2 columns: column 1 is Date & column 2 is ID. Note that each ID might have more than one date.

I want to create a third column showing the oldest date for each id. See example below

[ID] [Date ] [Result]
4 3/5/2014 3/5/2014
4 4/5/2014 3/5/2014
7 16/5/2014 16/5/2014
8 7/5/2014 7/5/2014
8 15/5/2014 7/5/2014

Is this possible for this to be done using Subset_min function?

Valentina · June 10, 2014 9:52AM

To be more specific I would eventually like to delete the id with the oldest date

Thanks in advance
Val

paola · June 10, 2014 9:58AM

In the DataManager space you can use Sort operation to sort the Data field in descending order, so oldest date will appear last in order.
New field will then establish relevant date for each ID
SUBSET_LASTNONNULL([Date], SUBSET([ID]))

You said each ID can have multiple dates against it, so not sure how would you create logic to delete the specific values?

Valentina · June 10, 2014 10:00AM

Thanks Paola

Welcome!

Categories

Ideas Parade

Tagged