Question

2
Replies
35
Views
Sulakkya Member since 2015 14 posts
evonsys
Posted: 2 months ago
Last activity: 1 month 2 weeks ago
Solved

How to use OLEDB query component.

I have a large excel file with around 300k rows. Issue - loading it to a lookup table, and looping through it, takes hours.

Can someone explain me how to use the OLEDBquery component to run a SQL in pega robotics studio?

Sample query;

(Select A,B,C from (\\network\abc.xlsx : sheet1) where X column = key)

Note: excel file is in a network location.

***Moderator: Pallavi to move from Discussion to Question***

Pega Robotic Process Automation 19.1 Robotic Process Automation Financial Services Robotics System Architect
Share this page LinkedIn