Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Split rows into different sheets

beatrizmguerreiro
8 - Asteroid

Hello, 

 

I have the following dataset:

StatusActivityUser ID
NewActivity 11234
In ProgressActivity 25678
In ProgressActivity 390123
CompletedActivity 490123

 

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"

StatusActivityUser ID
NewActivity 11234

 

Sheet 2 : rename to "In Progress"

StatusActivityUser ID
In ProgressActivity 25678
In ProgressActivity 390123

 

Sheet 3: rename to "Complete"

StatusActivityUser ID
CompletedActivity 490123

 

Thank you in advance.

11 REPLIES 11
vivaisun11
8 - Asteroid

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
6 - Meteoroid

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

Labels
Top Solution Authors