Question

2
Replies
52
Views
Close popover
Sulakkya Peiris (Sulakkya)
evonsys
Senior Software Engineer
evonsys
LK
Sulakkya Member since 2015 14 posts
evonsys
Posted: August 23, 2020
Last activity: September 3, 2020
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