OLEDB In UiPath

Patnaik14

Member
Hello,

Is there any option in UiPath, where we can run some sql query to get output from an excel sheet/Data table ?
If any option is there, please advice how to configure it.

Thank you.
 

bnastase

Member
Hello,

Is there any option in UiPath, where we can run some sql query to get output from an excel sheet/Data table ?
If any option is there, please advice how to configure it.

Thank you.


Hi

You can use the .Select function on your data table. What is it worth to mention is that the output will not be a data table but an array of rows. More info here https://www.uipath.com/kb-articles/how-to-filter-a-data-table

Also there is an activity called Filter Data Table which you can use on data tables. More info here https://activities.uipath.com/docs/filter-data-table

Bobby
 
Top