What is the significance of "Use Filter" option in excel read range activity

[tgopalas (Tanuja)]

Hi,

Plz help me

[Venkatesh_Chowdary (0099)]

@tgopalas

Hi,
No Significance i guess.

i used it but, with and without using filter, the result shows same.

Regards,
venkatesh.

[aksh1yadav (AKSHAY YADAV)]

@Venkatesh_Chowdary

No Significance i guess.

Hey @tgopalas and @Venkatesh_Chowdary

it has a significance.

When Use Filter checkbox is selected, the activity does not read what has been filtered out of the specified range. By default, this check box is not selected, and therefore the entire range is read, regardless if some information has been filtered out.

So when you are using Filter Table Activity to filter your data then you want your filter data to retain and so you can write it somewhere then this comes into the picture.

Regards.!!
Aksh

[tgopalas (Tanuja)]

@aksh1yadav As @Venkatesh_Chowdary said, the same result is coming when checking and unchecking.

[Venkatesh_Chowdary (0099)]

Hi @aksh1yadav

But both the times the result showing same.

theoretically it is correct but not showing the same.

regards,
venkatesh.

[tgopalas (Tanuja)]

test.xaml (7.6 KB)

[tgopalas (Tanuja)]

This is the excel file Filteredbytype.xlsx (9.5 KB)

[aksh1yadav (AKSHAY YADAV)]

@Venkatesh_Chowdary

theoretically it is correct but not showing the same.

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 …

How to get the filtered excel output in a datatable?

We are trying to get the filtered results from excel sheet in to datatable. Doing a ‘read range’ after filtering doesn’t seem to work as it takes the entire table.

Regards…!!
Aksh

[Sandip_Kumar]

Hi, Yes it does work if you unchecked the record from the filter and then try to read the data with using read range activity post pasting the information you will not be able to see the unchecked record in your data result.