Filter Table not executing

[rsuresh (Rachana Suresh)]

I want to put a filter on the excel table. but its not working. Can you please let me know if this is correct

[Dominic (Dominic Arul Collins)]

@rsuresh, Refer this,

Filter Table in excel data tables

hi @ask_565 You can use Filter Table Activity Within Available->App Integration ->Excel->Table->filter table and on Tables within an Excel File you can use it. By using This you can filter the table. It will require three data from your side: Sheet Name(on which sheet you wants to perform). Table Name(On which table you wants to use filter operation). Column Name( On which column basis you wants to perform the filter operation). As you asked About its “Filter Operation” Properties so …

Regards,
Dom

[rsuresh (Rachana Suresh)]

Hi,
Thanks for the reply.

i want to filter the column name so that it contains only one value. If i dont provide the filter options , what will the filtertable filter?

[rsuresh (Rachana Suresh)]

It gives me the same error with/without filter options.
It says “the table doesnot exists”. But i created the table through automation itself just before the filter table activity.

Can you please me know what the possible error could be

[Dominic (Dominic Arul Collins)]

@rsuresh,

@rsuresh

i want to filter the column name so that it contains only one value

you mean only distinct ones ?

@rsuresh

If i dont provide the filter options , what will the filtertable filter?

This will throw an error Required Filter Options

@rsuresh

the table doesnot exists”

This is where you could see your table name. Can you tell me how are you creating table using automation ?

Regards,
Dom

[rsuresh (Rachana Suresh)]

I go to Insert tab and them click on Table icon and create table.
To get the table name , i go to Design tab and get the table name as you have showed in screenshot

[rsuresh (Rachana Suresh)]

I have these things in the table

Name Age
A 27
A 23
A 17
B 23
B 21
B 25

I want to filter the table for name ‘A’ only.
Can you please let me know how it can be done through automation?

[arivu96 (Arivazhagan A)]

Hi @rsuresh,
Use this code to filter name is “A” alne
Dt =Dt.Select("Name='A'").CopyToDataTable()

Refer this for more information about datatable

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards,
Arivu