Add a new idea Subscribe
Status Completed
Categories Runtime
Created by Guest
Created on Aug 27, 2018

RELATED IDEAS

Collection Operation - highest or smallest value

Getting a smallest or highest value with an index
  • ADMIN RESPONSE
    Sep 7, 2022
    Hi Andre,

    In case you haven't seen the release notes, Collection operations action "Check if item exists in collection" has now been updated to be able to return the index when a value-match has been found.

    To extract the highest value in a collection, and then find its counterpart in a secondary collection:
    Sort items in the first collection, get the highest value
    Check if item exists in the original collection to get the Index
    Get item to pull the same Index from your secondary collection

    Please let me know if you have any further questions,
    Kate
  • Attach files
  • Guest
    Reply
    |     Sep 7, 2022
    Hi Andre,

    Thanks for reaching out! What is the scenario that you're trying to solve?

    Could you use "Sort items in collection" action to order the values asc/desc, and then "Get item from collection" to pull out the value at index=0?

    Regards,
    Kate
  • Guest
    Reply
    |     Sep 7, 2022
    I´m using two collections with the same index. In the first collection I have a category and in the second i have a probability. Now i want to get the probability with the highest value and the category. Therefore i need the index which is the same in both collections. Sort items in this case will not work.