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

Help Studio
, ,
1

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)

2

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

3

Hi Jack,

it is Sheet2

4

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

5

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

1 Like
6

delete what from sheet2?

7

which we are filtered data .

8

use this
Test.xaml (12.5 KB)
result

image
image320×535 4.67 KB

image
image434×543 5.33 KB

1 Like
9

Hi Jack

image "This is Sheet 2"
image "This is Sheet 2"813×272 5.08 KB

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
image

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

10

use write range in sheet2 with filter

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

11

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

12

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,