How to filter column values in excel using Filter data table activity

[gopal_krishna1 (gopal krishna)]

I am facing an issue with the table in excel sheet . I need to filter data in column 1as i getting the output but it’s copying and pasting it into another sheet, we need to separate data for the main sheet .(Sheet2 )

Attaching the excel file please check it .

Sheet 2 In this main sheet after filter data output will be writing sheet1.but my expected data is sheet 4.

suppsheet.xlsx (11.4 KB)

[jack.chan]

@gopal_krishna1
which is your main sheet? sheet1 or sheet2?

[gopal_krishna1 (gopal krishna)]

Hi Jack,

it is Sheet2

[jack.chan]

@gopal_krishna1
ok, then you want to get this result right、？

[gopal_krishna1 (gopal krishna)]

Yes Jack .
can we do like this after filtering data can we delete from sheet 2 .

[jack.chan]

delete what from sheet2?

[gopal_krishna1 (gopal krishna)]

which we are filtered data .

[jack.chan]

use this
Test.xaml (12.5 KB)
result

[gopal_krishna1 (gopal krishna)]

Hi Jack

This main sheet ,First we need know which data is present in column
so I using this Activities
excel app scope
Read range
Assign :ReadRange .DefaultView.ToTable(True,“Number”)
Write line : Assign
output show :5,3,1,1
the next step
Assign :ReadRange.Select("[Number]<> 5 and [Number]<>3 ").CopyToDataTable
Output Data Table
Write line :output Assign
It shows like :1
1
Write Range: writing the data in to sheet 1

After how can we delete from sheet 2 which was present in sheet 1 data.

[jack.chan]

use write range in sheet2 with filter

ReadRange.Select("[Number]<> 1 ").CopyToDataTable

[gopal_krishna1 (gopal krishna)]

Yes Jack
In column
5
3
is fixed value
Other than this two values they is any value we need move to another sheet

[willjoe2442]

Filter a range of data
Select any cell within the range.
Select Data > Filter.
Select the column header arrow .
Select Text Filters or Number Filters, and then select a comparison, like Between.
Enter the filter criteria and select OK.

Regards,