activities
latest
false
- Overview
- Callout
- Complex Scenarios
- Credentials
- Data Service
- Form
- Release notes
- Project compatibility
- Real Time Forms
- Updating form data
- Running forms using JavaScript
- Customizing Forms Using CSS
- Conditional components
- Adding multiple components on the same row in Columns
- Using the Data Table component
- Get File/Folder path
- Reading cell values from a Data Grid component
- Displaying PDF files
- Displaying images in forms
- Scrolling through Data Grids
- Using Dev Tools with forms
- Calculate form component values
- Managing dates in forms
- Opening hyperlinks inside forms
- Displaying a default tab in forms
- Displaying the full label of a component
- Searching long strings in drop-down lists
- About the pre 23.4 Form experience
- Project Compatibility
- Real Time Forms
- Dynamic Checkboxes
- Conditional Dropdowns
- Displaying a Default Tab
- Displaying Images
- Displaying PDF Files
- Displaying the Full Label
- Dynamic HTML Elements
- Managing Dates
- Searching Long Strings in Drop-downs
- Customizing Forms Using Local CSS Files
- Executing Do Block On Checkbox Change
- Customizing Columns Width
- Updating Form Data
- Resetting Collection Data
- Advanced Logic
- Executing Do Block on Dropdown Option Change
- Reading Cell Values From a Data Grid Component
- Conditional Components
- Scrolling Through Data Grid Components
- Using the Grid Component
- Dev Tools
- Calculated Value
- Dynamic Dropdowns
- Switching Tabs With Button Click
- Opening Hyperlinks Inside Form
- FTP
- IPC
- Persistence
- Release notes
- Project compatibility
- About the Persistence activity package
- Bulk Form Designer
- Start Job And Get Reference
- Wait For Job And Resume
- Add Queue Item And Get Reference
- Wait For Queue Item And Resume
- Wait For Form Task And Resume
- Resume After Delay
- Assign Tasks
- Create External Task
- Wait For External Task And Resume
- Complete Task
- Forward Task
- Get Form Tasks
- Get Task Data
- Get App Tasks
- Add Task Comment
- Update Task Labels
- Create App Task
- Wait For App Task And Resume
- Configure task timer
- Working with App tasks
- Building Your First Form Action
- Advanced Controls for Drop-downs
- Embedding Objects in Form Actions
- Allowing Users to Upload Files to the Storage Bucket
- Adding Advanced Logic Using Java Script
- Setting a Default Tab
- Removing the Delete button from Edit Grid using custom CSS
- Customizing Edit Grid templates
- Using buttons to trigger custom logic
- Using an External Form Layout
- Dynamically expanding form components at runtime
- Aligning the content of a form component from left to right using JSON attributes
- Sample Workflows
- Automation Ops Pipelines
- System
- Release notes
- About the System activity package
- Project compatibility
- Supported character encoding
- RegEx Builder Wizard
- Add Data Column
- Add Data Row
- Add Log Fields
- Add or Subtract from Date
- Add Transaction Item
- Add Queue Item
- Append Item to Collection
- Append Item to List
- Append Line
- Beep
- Break / Exit Loop
- Browse for File
- Browse for Folder
- Build Collection
- Build Data Table
- Bulk Add Queue Items
- Change Case for Text
- Change Type
- Check False
- Check True
- Clear Data Table
- Collection to Data Table
- Comment
- Compress/Zip Files
- Copy File
- Copy Folder
- Combine text
- Comment Out / Disabled Activities
- Continue / Skip Current
- Create File
- Create Folder
- Create List
- Custom Input
- Delete
- Delete File
- Delete Folder
- Delete Storage File
- Delete Queue Items
- Disable Local Trigger
- Do While
- Download file from URL
- Download Storage File
- Enable Local Trigger
- Evaluate Business Rule
- Exists in Collection
- Extract/Unzip Files
- Extract Date and Time from Text
- Extract Text
- File Change Trigger
- File Exists
- Filter Collection
- Filter Data Table
- Folder Exists
- For Each
- For Each File in Folder
- File Change Trigger V3
- Find and Replace
- Find Matching Patterns
- For Each Folder in Folder
- For Each Row in Data Table
- Format Date as Text
- Format Value
- Generate Data Table From Text
- Get Asset
- Get Credential / Get Orchestrator Credential
- Get Current Job Info
- Get Environment Folder
- Get Environment Variable
- Get File Info
- Get Folder Info
- Get Jobs
- Get Processes
- Get Row Item
- Get Transaction Item
- Get Username/Password
- Get Queue Items
- Global Variable Changed Trigger
- Input Dialog
- Invoke Code
- Invoke Com Method
- Invoke Power Shell
- Invoke Process
- Invoke VBScript
- Invoke Workflow File
- Is Text Matching
- Join Data Tables
- Kill Process
- Launch Workflow Interactive
- List Storage Files
- Log Message
- Lookup Data Table
- Manual Trigger
- Merge Collections
- Merge Data Table
- Message Box
- Modify Date
- Modify Text
- Move File
- Move Folder
- Multiple Assign
- New Item Added to Queue
- Notify Global Variable Changed
- Orchestrator HTTP Request
- Output Data Table
- Path Exists
- Postpone Transaction Item
- Process End Trigger
- Process Start Trigger
- Raise Alert
- Read List Item
- Read Text File
- Read Storage Text
- Remove Data Column
- Remove Data Row
- Remove Duplicate Rows
- Remove From Collection
- Remove Log Fields
- Replace Matching Patterns
- Repeat Number of Times
- Repeat Trigger
- Rename File
- Rename Folder
- Report Status
- Reset Timer
- Resume Timer
- Retry Scope
- Return
- Run Local Triggers
- Run Parallel Process
- Set Asset
- Set Credential
- Set Environment Variable
- Set Transaction Progress
- Set Transaction Status
- Should Stop
- Split Text
- Sort Data Table
- Start Timer
- Start Job
- Stop Job
- Stop Local Triggers
- Stop Timer
- Text to Left/Right
- Text to Upper/Lowercase
- Time Trigger
- Trigger Scope
- Timeout Scope
- Update Row Item
- Update List Item
- Upload Storage File
- Wait for Download
- Wait Queue Item
- While
- Workflow Placeholder
- Write Storage Text
- Write Text File
- AddDataRow
- AddQueueItem
- AddTransactionItem
- AppendLine
- BulkAddQueueItems
- ClearDataTable
- CompressZipFiles
- CopyFile
- CreateFile
- CreateFolder
- DeleteFileOrFolder
- DeleteQueueItems
- DeleteStorageFile
- DownloadStorageFile
- ExtractUnzipFiles
- FilterDataTable
- GetAsset
- GetCredential
- GetJobs
- GetQueueItem
- GetQueueItems
- GetResourceForLocalPath
- GetRowItem
- GetTransactionItem
- InvokeProcess
- JoinDataTables
- ListStorageFiles
- LookUpDataTable
- MergeDataTable
- MoveFile
- OrchestratorHTTPRequest
- OutputDataTable
- PathExists
- PostponeTransactionItem
- ReadStorageText
- ReadTextFile
- RemoveDataColumn
- RemoveDuplicateRows
- Replace
- SetAsset
- SetCredential
- SetTransactionProgress
- SetTransactionStatus
- SortDataTable
- StartJob
- StopJob
- UpdateRowItem
- UploadStorageFile
- WaitQueueItem
- WriteStorageText
- WriteTextFile
- Testing
- Release notes
- About the Testing activity package
- Project compatibility
- Project Settings
- Add Test Data Queue Item
- Address
- Attach Document
- Bulk Add Test Data Queue Items
- Create Comparison Rule
- Delete Test Data Queue Items
- Get Test Data Queue Item
- Get Test Data Queue Items
- Given Name
- Last Name
- Random Date
- Random Number
- Random String
- Random Value
- Verify Control Attribute
- Verify Documents Equivalence
- Verify Expression
- Verify Expression With Operator
- Verify Range
- Verify Text Equivalence
- Address
- AddTestDataQueueItem
- AttachDocument
- BulkAddTestDataQueueItems
- DeleteTestDataQueueItems
- GetTestDataQueueItem
- GetTestDataQueueItems
- GivenName
- LastName
- RandomDate
- RandomNumber
- RandomString
- RandomValue
- VerifyAreEqual
- VerifyAreNotEqual
- VerifyContains
- VerifyExpression
- VerifyExpressionWithOperator
- VerifyIsGreater
- VerifyIsGreaterOrEqual
- VerifyIsLess
- VerifyIsLessOrEqual
- VerifyIsRegexMatch
- VerifyRange
- Workflow Events
- Workflow Foundation
Filter Data Table
Workflow Activities
Last updated Nov 26, 2024
Filter Data Table
UiPath.Core.Activities.FilterDataTable
Enables you to filter a
DataTable
variable by specifying conditions in the Filter Wizard window. The activity can keep or delete rows or columns according to the logical conditions that are specified in the wizard.
The body of the activity contains a Filter Wizard button so that you can access the wizard and customize your settings at any time.
Important: Due to internal changes, this activity is no longer be visible in the Favorites list when upgrading to v20.4 or newer, if
it was added to the Favorites list with a v19.4 or older version of UiPath.System.Activities.
Properties
- DataTable - The
DataTable
variable that you want to filter. This field supports onlyDataTable
variables. - Filter conditions - The conditions used to filter the data table by.
Advanced options
- Action - Specifies whether to filter the table by keeping or removing the target rows.
- Filtered data table - The resulting filtered data table.
-
First row - The first row of the data table that matches the configured filters.
Properties
Common
- DisplayName - The display name of the activity. This field supports only strings or
String
variables.
Input
- DataTable - The
DataTable
variable that you want to filter. This field supports onlyDataTable
variables.
Misc
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
Options
- FilterRowsMode - Specifies whether to filter the table by keeping or removing the target rows. Select one of two options from the drop-down menu: Keep or Remove. The default value is Keep.
- SelectColumnsMode - Specifies whether to filter the table by keeping or removing the target columns. Select one of two options from the drop-down menu: Keep or Remove. The default value is Keep.
Output
-
DataTable - The resulting filtered
DataTable
variable. Using the same variable as the one in the Input field overwrites the initial variable, while adding a new variable leaves the initial one unaffected. This field supports onlyDataTable
variables.Note:- If you copy and paste a customized Filter Data Table activity inside the Designer panel, it does not retain its configuration.
- Excel ranges are not supported as input for this activity.
Filter Wizard
This wizard helps build the filtering options for a
DataTable
variable. It can be opened by using the Filter Wizard button in the body of the activity in the Designer panel. You can select
the DataTable
you want to modify as well as the one you want to save changes in, from the following fields:
- Input Data Table - The
DataTable
variable you want to filter. This field supports onlyDataTable
variables. - Output Data Table - The output
DataTable
variable. If the same variable that is present in the Input field is used, it is overwritten with the changes. Supplying a different variable does not modify the Input variable.
You can also select whether to filter by Row or by Column depending on the tab you select. There are two tabs, as follows:
Filter Rows Tab Field Descriptions
The Filter Rows tab enables you to filter a
DataTable
by Rows. To do so, you have the following options:
- Keep or remove matching rows - Specifies whether to filter the rows by keeping or removing them. This can be done by selecting the Keep or the Remove radio buttons. Selecting Keep only keeps the rows that meet the specified condition, while selecting Remove removes the rows that meet the specified condition.
- And/Or - Specifies the logical conjunctions to be used between conditions. This button is displayed only if you have more than one condition. By default, when you add a new condition, the button is displayed as And. Click the button to change its value to Or.
- Column - The name or index of the column that is to meet the condition.
- Operation - The logical condition that is to be met between the Column and the Value.
- Value - The value that is to be checked with the Operation and the Column.
-
Add/Remove Condition - Clicking the
+
button adds another sentence to the condition, while clicking thex
button removes a sentence.Note: When supplying a variable in the Column text box, you can use anInt32
variable to specify the column index, or aString
variable to specify the column name.
Output
The Output Columns tab enables you to filter a
DataTable
by Columns. To do so, you have the following options:
- Columns Selection Mode - Specifies whether to filter the columns by keeping or removing them. This can be done by selecting the Keep or the Remove
radio buttons. Selecting Keep only keeps the columns that are specified below, while selecting Remove deletes the rows that
are specified below from the input
DataTable
. -
Column - The columns you want to keep or remove from the
DataTable
.Note: When supplying a variable in the Column text box, you can use anInt32
variable to specify the column index, or aString
variable to specify the column name. -
Add/Remove columns - Clicking the
+
button adds another column, while pressing thex
button removes the column.Note: The order you add columns in the Wizard is the order that the columns are arranged in the output table.
Here you can see how the Filter Data Table activity is used in an example that incorporates multiple activities.