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)
You can try with Filter Data Table activity
Check out the XAML file
FilterStatus.xaml (6.3 KB)
Status_16092022_08_31 (1).xlsx (11.8 KB)
Try below steps
- Read Input Excel file and save it in dt_Input
- Filter the data table using column ‘Final SR status’
- save the filtered rows to dt_output
- write the output data table to Ouput Excel file
Filter_DataTable.xaml (7.8 KB)
i need to remove the status column “open” in first excel file after copying them to second output file.
Can you create a new topic for this. Other user may confused @vinjam_likitha
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.