We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Find Last in Group, emit entire row.

Comments

2 comments

  • Avatar
    Adrian Williams

    Hi Nick,

    you can use a Sort node to sort the data on the field containing your date values. Then within a Transform node configure the 'GroupBy' property with the field you used to sort the data. Then configure the ProcessRecords script to only output the record values if it is the last record in each group using the 'node.lastInGroup' built-in variable.

     

    1
    Comment actions Permalink
  • Avatar
    Nick Andrew

    Hugely appreciated. Thank you very much.

    0
    Comment actions Permalink

Please sign in to leave a comment.