Question

22
Replies
18620
Views
Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 141 posts
PEGA
Posted: August 23, 2016
Last activity: October 4, 2018
Posted: 23 Aug 2016 4:53 EDT
Last activity: 4 Oct 2018 13:54 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.