Filter excel table to remove particular rows

Help
, ,
12

Okay :smile: for that

  1. take Filter Table activity Excel Application Scope and set the workbook path.
  2. Set all the parameters like sheetName, ColumnName and table name. as shown in below shot.

image
for the table name, first you have to create table in excel and pass that table name in activity parameter

  1. Set the FilterOptions —> {“S*”}
    here S is just an example, so it’ll filter table on rows whose values starts with S.

I hope this’ll help you. @rishabh.jain :blush: