Articles → UIPATH → Filter Data Table Activity In Uipath

Filter Data Table Activity In Uipath






Purpose





Excel File




Picture showing the excel sheet with data to be filtered using Filter Data Table activity

Click to Enlarge


Example




  1. Drag and drop the "Excel Application Scope" activity and inside it, mention the excel file path.
  2. Inside the "Excel Application Scope" activity, add the "Read Range" activity to read the excel file. Assign the value to the data table "mydatatable".
  3. Add the "Filter Data Table" on the screen. Apply the filter and set the output to "outputdt" variable.
  4. Picture showing a filter wizard for applying filter on the data table

    Click to Enlarge

  5. Drag and drop the "Output Data Table" activity. Assign the value to the string variable "db".
  6. Finally, display the value of "db" in the message box.
  7. Picture showing the message box to display the filtered data in the data table

    Click to Enlarge

  8. Save and run the bot.

Output


Picture showing the output of the Filter Data Table activity in UiPath

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, February 16, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250