How to found latest date.

Follow

Kristian Westerstråhle

• November 27, 2017 11:25

Hi,

I have list of usernames and Login Dates.

Here is small sample

Username - Login date

Andy - 21/11/17

Andy - 15/11/17

Andy - 10/10/17

Ben - 19/11/17

Ben - 14/11/17

Ben - 12/10/17

 

I want found rows when Andy's and Ben's last login in happen.

What is best way to found it?

I using Dataverse 3.1.4

Br: Kristian W

 

0

• 

  Tim Segall

  • November 27, 2017 12:27

  Kristian,

  *** The following answer assumes you are on 3.1.6 ***

   

  Take the above output and output it into an Aggregate node.  Set the GroupBy to 'name' and the Operation to be Max of login and you should get what you want.

  Note: This assumes your login field is a date, if it is not you will need to use the Data Analyzer to convert to a date before passing into the Aggregate node.

  Regards, Tim.

  0

  Comment actions Permalink
• 

  Adrian Williams

  • November 27, 2017 13:04

  Further to Tim's answer see the attached example data flow.

  The example shows how the Aggregate node's max operator is used to find the latest date. Dataverse 3.1.6 is required as it provided the grid-based editor to simplify the configuration of the Aggregate node.

  The example also shows how the formatted date string can be converted to a date type field using the Python strptime() operator, see here for details.

  You will need Dataverse 3.1.6 to import the .lna  file.

  Attached files

  Find_latest_date - 27 Nov 2017.lna

  0

  Comment actions Permalink
• 

  Adrian Williams

  • November 27, 2017 13:10

  You may also be interested in the 'Working with Untidy Date Values' post.

  0

  Comment actions Permalink

Please sign in to leave a comment.