[InfoSet] - Performance # Filtering a Datatable - Index

[ppr (Peter Preuss)]

Introduction

Filtering a DataTable is a sub-step of automation processes that occurs frequently and that has to be implemented. There are several implementation options for this. In different experiments the performance of selected implementation options is recorded and extracted.

Set 1 # Essential Options

Option Selection

For an initial experiment the following implementation options are selected:

• Filter Data Table Activity
• LINQ Statement (Where Operator, Method Syntax)
• DataTable Class Select Method (Row Filter Syntax)
• For each Row in DataTable Activity based loop along with other essential Activities

Set Item	Links	Comment
Experiment Definition	WIP	measuring 1: close on the filter core part
Execution & Results	LINK	awaiting on publishing and linking

Resources

• Four Ways to Filter Data Tables in UiPath Studio | UiPath
• [HowTo] LINQ (VB.Net) Learning Catalogue

Docu

• DataTable.Select Method (System.Data) | Microsoft Learn

InfoSet Series - Performance

[InfoSet] - Performance # Information Index

About this [InfoSet] - Performance Series Performance and development are interlinked. The choice of how a particular task is implemented / modeled can affect its execution speed. This information index is the landing page that lists all the different information resources. Introduction In order to be able to evaluate implementation options, these are investigated further. If possible, the following basic pattern is applied. Selection of a topic / Insertion to an existing topic Investigati…

Credits

Thank you very much for your cooperation and support.

• @jeevith

Questions

For questions on your specific case or performance topic open a new topic and get individual support.