Visokio website     Downloads     Video tutorials     KnowledgeBase  
Subset functions: identify earliest Date(s) in a field? - Visokio Forums
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
  •     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

    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
This discussion has been closed.
← All Discussions


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership