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?
(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***