To seperate excel into two sheets using one condition

Learning Initatives Automation Starter
1

Screenshot (3)
Screenshot (3)1366×768 92.8 KB

I need to separate this excel into two sheets with the condition status as “error” or “completed.” Please help with your valuable contribution am a beginner in the RPA field
thanks in advance

2

Hi @sarath_babu,

Welcome to community.

  1. Read excel with read range activity.
  2. Filter “failed” using the Filter activity.
  3. Filter “completed” using the Filter activity.
  4. Write the tables you created on different sheets.

Please share your feed if you have problems doing these steps.

Regards,
MY

3

Thank you so much. It means a lot to me. I will try all these out and will let you know the results soon. Wishing you a great day ahead

4

Can you please elaborate on the 4th step you have mentioned in this?

5

Hi @sarath_babu ,

As @muhammedyuzuak mentioned the steps

  1. Read excel with read range activity. → dt_result
  2. Filter dt_result with “failed” using the Filter datatable activity. → dt_Failed
  3. Filter “completed” using the Filter activity. → dt_Completed
  4. Write the tables you created on different sheets. (as you have two data tables, you can write it to two sheets)

Regards

6

I am facing some issues with the filter activity , for getting both faild and completed stored am using for each statement and facing issues for placing filter activity

7

Hi @sarath_babu ,
Give column name as Status in filter data table activity on left side and on right side give “error”.
This will filter only rows which consists of error.
Same do for “Completed” also.
And write the data on separate excel sheets.

Regards,
LAKSHMI

8

@sarath_babu ,
Place filter data table activity after reading the excel file.
Don’t put inside for each.
Regards,
LAKSHMI

9

Screenshot (4)
Screenshot (4)1366×768 110 KB

good morning,
I would like to let you know that I have tried doing the steps you have mentioned here, I tried the filter data table activity, and may I know which statement is used to create a new sheet in the same excel and store the filtered data.
Wishing you all a great Sunday. Thank you

10

Hi @sarath_babu ,

kindly use Write range activity to write the datatable,
you may need to check the documentation to specify the sheet name
please note that there are classic activities and modern activities to use,
regards