Question

2
Replies
75
Views
Sulakkya Peiris (Sulakkya)
evonsys
Consultant
evonsys
LK
Sulakkya Member since 2015 15 posts
evonsys
Posted: August 23, 2020
Last activity: September 3, 2020
Posted: 23 Aug 2020 4:57 EDT
Last activity: 3 Sep 2020 16:15 EDT
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