I need to copy data from one excel to another excel based on filtering one column

Help Studio
, ,
1

Hi ,

This is my output file.
Status_16092022_08_31 (1).xlsx (10.7 KB)

From this file i need to filter last column if the Final SR status is “open” then those rows i need to copy to another excel file.
Below is the attachment after filtering the above file

Status_16092022_08_31 (1).xlsx (10.4 KB)

Thanks
Likitha

2

HI @vinjam_likitha

You can try with Filter Data Table activity

Regards
Gokul

1 Like
3

Hi @vinjam_likitha

Check out the XAML file

image
image1000×567 29.9 KB

FilterStatus.xaml (6.3 KB)

Output

Status_16092022_08_31 (1).xlsx (11.8 KB)

Regards
Gokul

2 Likes
4

Hi @vinjam_likitha

Try below steps

  1. Read Input Excel file and save it in dt_Input
  2. Filter the data table using column ‘Final SR status’
  3. save the filtered rows to dt_output
  4. write the output data table to Ouput Excel file

image
image1311×772 42.5 KB

image
image808×568 13.3 KB

Filter_DataTable.xaml (7.8 KB)

Thanks
John

5

Hi ,

Thanks for the Solution.

1 Like
6

Hi,
i need to remove the status column “open” in first excel file after copying them to second output file.

Thanks
Likitha

7

Can you create a new topic for this. Other user may confused @vinjam_likitha

Regards
Gokul

8

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