Articles → UIPATH → Filter Data Table Activity In Uipath
Filter Data Table Activity In Uipath
Purpose
Excel File
Click to Enlarge
Example
- Drag and drop the "Excel Application Scope" activity and inside it, mention the Excel file path
- Inside the "Excel Application Scope" activity, add the "Read Range" activity to read the Excel file. Assign the value to the data table "mydatatable"
- Add the "Filter Data Table" on the screen. Apply the filter and set the output to "outputdt" variable
Click to Enlarge
- Drag and drop the "Output Data Table" activity. Assign the value to the string variable "db"
- Finally, display the value of "db" in the message box
Click to Enlarge
- Save and run the bot
Output
Click to Enlarge