How to use filter table activity? please let me know the details on “Filter options” property.

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). …

Hi @aksh1yadav , Very helpful filter table snippet. I executed the filter table snippet that you have attached in UI path. I noticed that the workbook file path is automatically entered in JSON file. Can you please send me the init process for this, which automatically pulls the path for the wor…

How to filter multiple column under single Application scope ? and write it in separate excel sheet

Hi @blaze.1411 , I have verified the documentation . It doesn’t have multi column information. But I have tried with another way to use multi column filter. I don’t know this is the way for multi column or not. But it is working that to add another filter table activity. [image] Filter …

How can you write the filter data into new sheet ?

Hi @blaze.1411 , Check the “Use Filter property” in the read range. [image] Regards Balamurugan

[image] blaze.1411: and write it in separate excel sheet Check existing thread : How to get the filtered excel output in a datatable? - #4 by aksh1yadav Regards…!! Aksh

Hi @aksh1yadav , Yes. The sample is also having the same what I have mentioned above. But it is good. Regards Balamurugan.S

i used the vb.net code to filter multiple column from excel ExactData.Select(“[Column Name] = ‘Value’ AND Column Name= ‘Value’”).CopyToDataTable under assign activity .CopyToDataTable is to convert DataRow to DataTable

Hi @blaze.1411 , If you go with this option , you don’t want to use the filter table activity. It is good. Regards Balamurugan

Filter Table in excel data tables

Help

balupad14 (Balamurugan (BalaReva)) May 14, 2018, 10:17am 13

Hi @blaze.1411,
Check the “Use Filter property” in the read range.

Regards
Balamurugan

Excel append range problem

Topic		Replies	Views
Excel Filter Table Activity Help	18	4320	December 6, 2019
Filter data table in excel Activities excel	20	1978	May 26, 2022
How do I Filter Excel COLUMN Help	32	9790	July 19, 2019
Deleting rows from a sheet after filtering Help excel	34	7756	March 28, 2018
Filter Table activity Help activities	25	1886	August 28, 2019

Filter Table in excel data tables

Related topics