Question

22
Replies
18372
Views
Chunzhi_Hong Member since 2013 138 posts
PEGA
Posted: August 23, 2016
Last activity: October 4, 2018
Closed
Solved

OpenSpan7.1 How to lookup values from a table of record which is stored in an excel workbook

I wanted to convert a code to its name (ex. 001 -> USD, 002 -> GBP).

The code & name pare is stored in an excel work book and I have implemented an automation which loops over all lines of record and return the matching name.

However, the automation looks a bit combursom and I wanted to know if there is any smarter way (like excel lookup function), where I don't need to implement a loop at all.

***Updated by moderator: Lochan to add Categories***

***Updated by Moderator: Marissa to update categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Reporting Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn