Blue Prism Product

last person joined: yesterday 

Chat about Blue Prism products
Expand all | Collapse all

Perform Vlookp in Blueprism

  • 1.  Perform Vlookp in Blueprism

    Posted 23 days ago
    Hi,

    I would like to perform VlookUp in Blueprism. Is it possible? if Yes, then how.

    BR/Asitabha

    ------------------------------
    Asitabha Deb
    ------------------------------


  • 2.  RE: Perform Vlookp in Blueprism

    Posted 22 days ago
    Hi,

    Yes its possible,You have to write code to achieve same in excel using Blue prism.

    Thanks
    Nilesh

    ------------------------------
    Nilesh Jadhav
    Senior RPA Specialist
    ------------------------------



  • 3.  RE: Perform Vlookp in Blueprism

    Posted 17 days ago
    If you're saying you have a value that you know to be in one column of a collection and you want to retrieve a value from another column in the same row, then the easiest way is with Utility - Collection Manipulation::Filter Collection. Assuming that the value you're looking up is unique, it will return a single row. You just store that result into a new collection that will then only have one row and you just need to use a calculation stage after that to get the value from the other column like [collectionname.otherfieldname] and store it wherever, etc.

    ------------------------------
    Dave Morris
    Cano Ai
    Atlanta, GA
    ------------------------------