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

excel
activities
studio

#1

Hi,

Plz help me


#2

@tgopalas

Hi,
No Significance i guess.

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

Regards,
venkatesh.


#3

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


#4

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


#5

Hi @aksh1yadav

But both the times the result showing same.

theoretically it is correct but not showing the same. :stuck_out_tongue:

regards,
venkatesh.


#6

test.xaml (7.6 KB)


#7

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


#8


Regards…!!
Aksh