Split rows into different sheets

[beatrizmguerreiro]

Hello, 

I have the following dataset:

Status	Activity	User ID
New	Activity 1	1234
In Progress	Activity 2	5678
In Progress	Activity 3	90123
Completed	Activity 4	90123

Based on the "Status" , is it possible to split the rows into different sheets, in an excel output?

- Keep table structure  

- Rename sheets with Status' name.

Expected end result:

Sheet 1: rename to "New"

Status	Activity	User ID
New	Activity 1	1234

Sheet 2 : rename to "In Progress"

Status	Activity	User ID
In Progress	Activity 2	5678
In Progress	Activity 3	90123

Sheet 3: rename to "Complete"

Status	Activity	User ID
Completed	Activity 4	90123

Thank you in advance.

[vivaisun11]

Hi. This is super helpful. Thanks for the solution.

Is it possible to do this, AND also create a new file (with date in the file name) each time the workflow runs?

[ancook]

Hello, I am getting the error message Output Data: No file is specified in the configuration. What am I doing wrong?