Filter data in excel

Hello, i have excel file with some data and i want filter this data. how can i choose specific items in this filter ?

Thanks.

1 Like

there is filter data table activity in activities panel

1 Like

Use filter table activity
As per your requirement , filter based on the criteria

1 Like

Hi @Hozy

Regards,
Kommi Jeevan.

2 Likes

Hi @Hozy

You can easily use Filter Dattable activity and also you filter data with out using that activities.

you can refer to this activites for your reference. Please read. :smiley:

cheers :smiley:
Happy learning :smiley:

2 Likes

Hi
There are two ways to do this buddy
Either we can use FILTER DATATABLE ACTIVITY
Where first read the datatable with Read range activity and get the datatable with variable named dt and pass dt to filter datatable activity and set the condition we want to get filtered and get the output with a variable of type datatable named Finaldt

Or

We can use SELECT METHOD with a simple assign activity like this
dt = dt.Select(“[yourcolumnname1] = ‘your value’ AND [yourcolumnname2] = ‘yourvalue’ “).CopyToDatatable()

We can have = or > or < symbols as well and also use other conditional operators like OR, AND between two filter conditions Like we do in filter datatable activity

Cheers @Hozy

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.